Create a simple select query with a wizard

The Simple Select Query Wizard creates queries that retrieve data from the fields you specify in one or more tables or queries. If you want, the wizard can also sum, count, and average values for groups of records or all records, and it can calculate the minimum or maximum value in a field. You can't limit the records it retrieves by setting criteria, however.

1. In the Database window, click Queries under Objects, and then click New on the Database window toolbar.
   
   
2. In the New Query dialog box, click Simple Query Wizard.
   
   
3. Click OK.
   
   
4. Click the name of the table or query you want to base your query on, and then select the fields whose data you want to retrieve.
   
   
5. Click an additional table or query if desired, and then select the fields you want to use from it. Repeat this step until you have all the fields you need.
   
   
6. Follow the directions in the wizard dialog boxes. In the last dialog box, you can choose either to run the query or to see the query's structure in Design view.

   If the resulting query isn't exactly what you want, you can rerun the wizard or change the query in Design view. For more information on changing a query in Design view, click .

To troubleshoot problems with the query, click .