Trouble with Summary Report

S

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
 
L

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top