G
Guest
I know this has to be possible to do, but I can't figure out how. Please help!
I have to put together an employee hours report:
- Along the top of the page will list each month.
- Along the side of the page will list the different types of hours an
employee can report. There can be multiple items within each type (i.e.
OTHER can include Personal Time, Holiday Time, etc.).
- I need to list each individual line and then sum the total hours for each
type.
How do I do this without creating a separate query for each month. I don't
want to have to create a new query each month. I need to run this report by
employee.
Thanks for your ideas!!
I have to put together an employee hours report:
- Along the top of the page will list each month.
- Along the side of the page will list the different types of hours an
employee can report. There can be multiple items within each type (i.e.
OTHER can include Personal Time, Holiday Time, etc.).
- I need to list each individual line and then sum the total hours for each
type.
How do I do this without creating a separate query for each month. I don't
want to have to create a new query each month. I need to run this report by
employee.
Thanks for your ideas!!