Sum of a Count (1 Viewer)

moleary

Senior Member
Local time
Today, 23:12
Joined
Feb 9, 2001
Messages
58
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
 

llkhoutx

Registered User.
Local time
Today, 17:12
Joined
Feb 26, 2001
Messages
4,018
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.
 
R

Rich

Guest
Is your report grouped by supervisor or location, is there only one supervisor for each location?
 

Users who are viewing this thread

Top Bottom