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.

How to create a Form for a Query or Table in Access. In this article, we will create the form by using the form tool called Form, which is the simplest of them all.

Access uses wizards to simplify the process of creating reports or queries that select and retrieve information from your databases. Queries are instructions to the database that ask for information.

Click on the Query object in the Database window and click New. (In Access 2007, click the Create tab and then click Query Design in the Other group.) Add all the fields you want to your query.

In Microsoft Access, a Relationship helps you to merge or link data from one table to another. Relationships allow the user to create Queries, Forms, and Reports.When tables are created for each ...

Rather than having users remember how to use wildcards, you can create a parameter query that allows them to enter just the string of characters they’re looking for. Follow these steps: Open the ...

How to Create a Table From Query Results in Microsoft SQL. If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results.