The Query Design: Create a new blank query in Design View. You can use the Show Table dialog box to add queries and tables to the Query Design. What are the Advantages of using a Query?

Learn how to use SQL in Microsoft Access with this step-by-step guide, complete with examples, FAQs, and tips for better database management.

Create a query from within Access that attaches to my SQL Server and retrieves the recordset. I'd likely use the same technique I applied in this thread. <BR>2.