Microsoft Office Tutorials and References
In Depth Information
• Click the Next button to
display the next Crosstab Query
selecting ﬁ elds for
row and column
• Click the Amount Paid ﬁ eld to
select the Amount Paid ﬁ eld for
• Click other ﬁ elds. For each ﬁ eld,
examine the list of calculations
that are available. When ﬁ nished,
click the Amount Paid ﬁ eld again.
ﬁ eld selected
• Click Sum to select Sum as the
calculation to be performed
My list of functions is different.
What did I do wrong?
Either you clicked the wrong ﬁ eld,
or the Amount Paid ﬁ eld has the
wrong data type. If you mistakenly
assigned it the Text data
type for example, you would not
see Sum in the list of available
• Click the Next button to display
the next Crosstab Query Wizard
• Type Client-Recruiter
Crosstab as the name of the
query (Figure 2–81).
• Click the Finish button to produce
the crosstab shown in Figure 2–75
on page AC 122.
• Close the query.
If I want to view the crosstab at
some future date, can I just open