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
click Next.
Figure 4-4:
Choose the
field(s) you
want to use
as column
headings.
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.
Figure 4-5:
Choose how
to group
date and
time data.
Search JabSto ::




Custom Search