Nick,
If you want your report to look exaclty like what you have, you might want to do some vba coding to create a new temp table. Have your code run through each record and concationate two records together to give you the desired report. You can then use the existing report. This way if...
Dawn,
Your grouping method does work. My requirements are to have the names of the employees on the left and the hours they worked each month in their own column on the right. The report would look like:
Employee Jan Fed Mar April Total
John Doe 5 2 4...
I am trying to create a report that will show billing hours for employees based on the month and then sum each month and year end totals. I have been playing with the cross-tab query, but can not figure how to break down based on the month. It will only total for the entire table.
Kevin
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.