Microsoft Office Tutorials and References
In Depth Information
Querying a Database
Figure 17-12:
The
Crosstab
Query
Wizard
dialog box
asks you
to choose
which
database table
to use.
Figure 17-13:
The first
step to
creating a
crosstab
query is
to choose
up to three
fields to
identify
each
record.
7. Click Next.
Another dialog box appears, asking for a single field to use to
crosstabulate data with the fields you chose in Steps 5 and 6, as shown in
Figure 17-14.
8. Click a field name and then click Next.
Ideally, this field should consist of text information that lists different
data, such as sales regions (East, West, North, or South) or products
(Missiles, Unicorn meat, and so on). If you choose a field that contains
numerical data, your crosstab query displays only those numbers in the
column headings, which will appear meaningless. Another dialog box
appears, as shown in Figure 17-15.
 
Search JabSto ::




Custom Search