In the database attached, the report, rpt_Training_Employees, lists employees and the training they've received. I need to list the number of unique employees in the top of the report, with, "There are x employees in this report". Since each employee is identifed by User_ID, I tried to total on that, but it gave me a count for each training the employee has and totalled those over the whole report. That would actually be the total training on the report. I don't need that. Instead, I need the total of unique employees listed. In this report, it would seem there are six, but one is listed twice for AM and PM shifts, so there should only be a count of five. I'd like this total in the report header.
I worked through this solution here: http://www.experts-exchange.com/Database/MS_Access/Q_28607256.html?searchSuccess=true&searchTop10=true
, but as the author pointed out, it just gives a total count of the values in the dataset of the query. It doesn't account for when a parameter has limited the number of users in the report. If you want to see how I would limit the report with parameters, see the form, frm_TrainingByEe.