Microsoft Office Tutorials and References
In Depth Information
Creating a Query with the Simple Query Wizard
fields for the
When you select a table or query, fields from that object appear in the
Available Fields list box.
4. Move the fields you want to use in the query from the Available Fields
list to the Selected Fields list by double-clicking a field name (or
selecting the field name and then clicking the > button).
5. If you’re using fields from more than one table or query, repeat Steps
2 and 3 to add fields from other tables or queries to the Selected
Fields list; then click Next.
From this point on, the windows you see depend on the types of fields
and the type of query (detail or summary) you choose.
6. Choose the type of query you want: Detail or Summary.
7. Depending on your selection in Step 6, do one of the following:
• If you chose a summary query, click the Summary Options button.
• If you chose a detail query, click Next, and jump to Step 11.
The Summary Options window appears, as shown in Figure 1-5, allowing
you to tell the wizard how to summarize each field. Choose these
summary calculations carefully. In some cases, you may need to write a
calculation in the query to get the data that you need; the summary options
may not be sufficient.
8. Choose how to summarize your data, click OK to close the Summary
Options dialog box, and click Next to see the next window of the
9. Select check boxes to indicate the new fields that you want Access to
If you want to add all the values in the Qty field, for example, to
calculate how many items have been sold, select the Sum check box in the
row for the Qty field.