Department Count in report header/footer

[Bruce927]

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

[NeoPa]

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.

[Bruce927]

Thank you. I only have one level of grouping. This works fine.

[NeoPa]

8-) Good to hear it Bruce.