469,642 Members | 1,227 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,642 developers. It's quick & easy.

Calculating grand total from Crosstab query for a counts in rows

Hi, I'm new to access 2003 & would like to know how to create a report that shows the grand total of counts, details are as the following:
1) I've a database of credit cards where I would like to generate a monthly report for all sales-men & total count of approved cards for each (ex. in AUG).
2) A simple query is created to retreive the required data such as: serial no, sales code & card status(approved only)
2) Then Crosstab query is created to use the staff code as row, approved cards as column & count of serial in data field.
3) Results was as the following:
F18 21
F20 5
F03 6

Now the question is: How can I calculate in a report the sum of serial no count for all (21 + 5 + 6) = 32 to be shown as grand total????

Appreciating your patience & valuable advice..
Attached Files
File Type: zip access pivot report.zip (134.4 KB, 209 views)
Aug 19 '09 #1
0 2904

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by The Bit Bandit | last post: by
2 posts views Thread by Nenad Markovic | last post: by
5 posts views Thread by Nobby | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.