David Bigelow
asked on
How do insert a count of a given criteria in a report?
In my attached report, I'm trying to get a count of the employees in various employement statuses: furloughed, on leave, nonwork, etc.
I understand how to get the count in the query, but I don't know how to pull it into the report.
SampleSkills.accdb
I understand how to get the count in the query, but I don't know how to pull it into the report.
SampleSkills.accdb
On which report do you need the count ?
ASKER
That would be helpful information! rpt_Employees_Supervisor. Fields are in upper left of report.
In the ContronSource on each textbox enter =DCount("User_ID","tbl_AM_ Operators" ,"Status=1 ")
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so much! DCount crossed my mind, but I'm not versed with using it.