Report formating by month

[brodi]

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

 

[dawnd3]

Just a regular report and group by date and then go into the grouping options (right click in report design and choose "sorting and grouping) and specify "month" in the "group on" property (for the date field). Let me know if this helps you.

Dawn

http://www.calliopeconsulting.net

 

[brodi]

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 2 13
Jane Doe 1 2 3 4 10

Totals: 6 4 7 6 23


It is a little tricky. I have played with the cross-tab querries. I managed to get the querry to total all the employees hours, but I just can not figure how to show the report in the above format.

Kevin

 

[dawnd3]

I am not sure how to do that. I would think a crosstab would work, but I would have to see your tables....I think there is an option in the crosstab report wizard to group by month. I am sure you can do what you want to do in VBA but I don't know. Anyone have any ideas?

http://www.calliopeconsulting.net