Can you do a sum of a count in a report? What I need is I have supervisors by location totaled but I need to total that total. When I do I get this huge number like 2683 but really I want to know that there is 6 supervisors for all locations
It seems to me that you need a query to determine the total number of supervisors, then use a DLookup on that query as the recordsource for that field on your report.
