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

Department Count in report header/footer

P: 23
I have a report in access that is grouped by Department. but I want to summarise the contents so that I can count the number of Departments in the report, evey method I have tried has yielded the total number of times each department is entered in the table. For example I if i have 5 people from two different departments (each dept has 5 people) the result I get is 10 when I am expecting 2.
Thank you in advance
Oct 4 '11 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 15k+
P: 31,433
How many levels of grouping do you have in your report. Have you tried a control on your department footer that has a value of one but the property Running Sum set to True? The value of that control at the end of the report should be the value you need.
Oct 5 '11 #2

P: 23
Thank you. I only have one level of grouping. This works fine.
Oct 5 '11 #3

Expert Mod 15k+
P: 31,433
8-) Good to hear it Bruce.
Oct 5 '11 #4

Post your reply

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