Trouble with Summary Report

[Steve]

Hello,

I have run into a snag. I am trying to create a report that groups
information by month. The report summarizes how many activities took place
by month by a given day of the week. The report also averages the amount of
square footage used for all the activities for that month. All of the
information is coming from a single query. I am able to get all of the
information in the report that I need. As displayed by the following
samples, I am not able to make it look the way I would like it to look.

I am able to create the report like this:
TOTAL Monthly
MONTH Tue Wed Thu Fri Sat # Days Sq. Ft.
Jan-03 2 2 1,250
Jan-03 3 3 2,157
Jan-03 2 2 901
Jan-03 6 6 1,529
Feb-03 4 4 1,148
Feb-03 3 3 2,129
Feb-03 3 3 1,027
Feb-03 2 2 1,275
TOTAL 25 11,416

Or like this:
TOTAL Monthly
MONTH Tue Wed Thu Fri Sat # Days Sq. Ft.
Jan-03 13 13 1,459
Feb-03 12 12 1,395
TOTAL 25 2,854

But unfortunately I am not able to make it appear the way I would like:
TOTAL Monthly
MONTH Tue Wed Thu Fri Sat # Days Sq. Ft.
Jan-03 3 2 6 2 13 1,459
Feb-03 5 7 12 1,395
TOTAL 25 2,854

Thank you for your help.

Steve

 

[Larry Linson]

If you'd describe in some detail what data you have, how your tables are
laid out, and the SQL of the query you are using to summarize, it is
possible that someone might be able to give you a suggestion.

Larry Linson
Microsoft Access MVP