Microsoft Office Tutorials and References
In Depth Information
Using the Crosstab Query Wizard
If you want the option of grouping date values, don’t pick a Date/Time
field here; use it for column headings instead.
5. In the new window that appears, shown in Figure 4-4, select the
field(s) whose values you want to use as column headings and then
want to use
You can select only one field to use as the column headings. You may
want to use a field containing dates and tell Access to group date values.
6. If you select a date field as the column headings, you see the window
shown in Figure 4-5; choose how to group dates and then click Next.