Microsoft Office Tutorials and References
In Depth Information
5
Click the Next button to
display the next Crosstab Query
Wizard screen.
selecting fi elds for
calculations for
row and column
intersections
Click the Amount Paid fi eld to
select the Amount Paid fi eld for
calculations.
I
Experiment
Click other fi elds. For each fi eld,
examine the list of calculations
that are available. When fi nished,
click the Amount Paid fi eld again.
Sum
function
selected
Amount Paid
fi eld selected
Click Sum to select Sum as the
calculation to be performed
(Figure 2–80).
My list of functions is different.
What did I do wrong?
Either you clicked the wrong fi eld,
or the Amount Paid fi 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
calculations.
Next button
Figure 2–80
6
Click the Next button to display
the next Crosstab Query Wizard
screen.
name of
crosstab
query
Type Client-Recruiter
Crosstab as the name of the
query (Figure 2–81).
7
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
the query?
Yes.
Finish
button
Figure 2–81
Search JabSto ::




Custom Search