Microsoft Office Tutorials and References
In Depth Information
Creating a Query with the Simple Query Wizard
Don’t overlook the Count check box(es) that may appear in this window.
Selecting a Count check box tells the wizard to create a field that counts
the records within each grouping.
10. If the fields being summarized can be grouped by a Time/Date field,
you see a window where you can choose to group data by date;
choose the time interval the records should be grouped by and then
You won’t see this window if your data doesn’t contain a Time/Date field.
If you choose to include the Order Date field in the query and to sum
the Qty field, for example, you can group by month to see how many
units of each item you sold in each month. You can choose to display
totals by the following date grouping options: Day, Month, Quarter, and
Year. The Unique Day/Time option groups records by each unique date
and time; if your data includes times, all records with the same date and
time are grouped together. If your data includes only a date without the
time, all records from the same day are grouped together (the same as
the Day option).
11. Type a name for the query in the box at the top of the window.
12. Choose one of these options:
Open the Query to View Information: This option shows you the query •
in Datasheet view.
Modify the Query Design: This option shows you the query in •
13. Click Finish to view the query.
If you chose the Open the Query to View Information option in Step 12,
you see the query in Datasheet view, shown in Figure 1-6. If you chose
the Modify the Query Design option, you see your resulting query in