By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
461,940 Members | 791 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 461,940 IT Pros & Developers. It's quick & easy.

Calculating grand total from Crosstab query for a counts in rows

P: 1
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 (134.4 KB, 196 views)
Aug 19 '09 #1
Share this question for a faster answer!
Share on Google+

Post your reply

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