Create a select query without a wizard

You can use the steps in this topic to guide you through creating a select query from start to finish. You’ll use many of these steps in creating every query. The others you’ll use when you design a query that specifies criteria used to select information, perform calculations, or set a sort order. You need to use only the steps that are relevant to the data you wish to retrieve. For other tasks related to creating queries, ask the Answer Wizard.

1. Add a table to a query

   Ways to bring together data from multiple tables or queries in a query

   Add a table or query to a query

   Join multiple tables and queries in a query

   Change the type of join between tables and queries in a query

2. Add fields to a query

   Add fields to the design grid in a query

   Add a column to the design grid in a query

3. Set query criteria to select specific information

   About using criteria in queries to retrieve certain records

   Enter criteria in a query to retrieve certain records

   Insert or delete a criteria row in a query to retrieve certain records

4. Perform calculations in a query

   Create a field that performs custom calculations or manipulates field values in a query

   Examples of expressions that calculate on or manipulate values by using a calculated field

5. Refine a query

   Set properties for a query, its fields, or its field lists

   Sort records by using the design grid of a query

   Create an AutoLookup query that automatically fills in data

   About AutoLookup queries that enter data automatically