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 Use Web Query Files With Access. Web query files are spreadsheets that Microsoft Excel creates using data ... Click the radio button labeled "Link to the data source by creating a linked ...