I have an issue with counting records. In both reports all records and the one filtered by Director, I need to total up the records in the employee info table and have the count available for a calculation in the reports, Takes the total hours and divides by the number of employees. In the filtered form, Director Report Date I would like it to go and tally the records of all the employees for the director chosen in the form each time the report is run so if they add employees the calculation will always be current. The same thing needs to happen for the ALL employee report... count all records and store. Should this be controlled by the form? I have included an updated copy of the mdb.
Sinndho, thanks for the code. I understand what it is supposed to do, however I am still confused on where I should place it in the control forms. frmDirector Report Date. Sorry for the ignorance with Access, but the last time I did anything in Access was many years ago. Can you insert the code where it belongs in the form? The new object has been created.
I have the Associate directors reports working, but not the report that shows all employees. I cannot figure out a way to total up the employees in the Employee Info table and bring that total into the report. Also, there is an issue with the training types duplicating on the report that shows all employees. If there is one employee from each director with the same training type, the report will list it twice instead of a consolidated entry. I have attached the mdb for clarification.