Microsoft Office Tutorials and References
In Depth Information
Querying a Database
up to three
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
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.