Two Sets of Variables

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

Want to put 2 sets of variables on the report - am emloyee list and hours
worked by department with a grand total in the report footer.
As the employee numbers will vary so will departments.
ie n employess and y departments.
Is it possible to do this in an Access report??
 
Sorry - made hash of explanation

Could be 10 employess and only 2 departments or 15 employees and 8
departments.
Need to do employee and department totals and grand total at end.
Can get employee totals to work well but departmental total seem to be cut
off if more than 1.
Grand total at end (in report footer) always works well.
 
Kevin.
I assume you have the appropriate select query as the
source for your report.
What you should do is group by Employee and Department
So in your grouping you would indicate [Emplyee] &
[Department]
Now you'll be able to summarize.
Hope this helps.
Fons
 
Back
Top