Department Performance's and Totals

[Neil Greenough]

I have a contact list which has a subform in containing performance
indicators for specific months for that individual (the sub form is linked
to a performance table). In this contact form, each contact is assigned to a
department.

I have set up a query which allows me to select a contact and a date and it
returns their performance indicators for that specific month in a report.

Now, what I would like to be able to do is select a department and a date
and for a report to be returned that contains a total of all the workers
within that specific departments' performance indicators for that specific
month.

 

[Guest]

It sounds like you've done most of the work. I'll assume that you can pull
together the data at the department level and aggregate as appropriate.

From there, go ahead and build your report. You can pass the criteria for
department the same way you currently do for your employee based query. If
you have the report triggered by clicking a command button, the wizard will
do most of the coding for you. You might want to add code to be certain that
a department has been selected.

Hope that helps.