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

 

[Douglas J. Steele]

Try creating a second query based on your existing query, and summing the
individual fields:

SELECT [Month], Sum(Tue), Sum(Wed),
Sum(Thu), Sum(Fri), Sum(Sar),
Sum(Total # Days), Sum(Monthly Sq. Ft.)
FROM MyQuery
GROUP BY [Month]

 

[Duane Hookom]

Please share your table structures and SQL.

 

[Steve]

Thank you. Although I did try creating a second summary query earlier, your
response to my request for help led me to try some additional options.
Thank you so much. The report is working beautifully.

Steve

Try creating a second query based on your existing query, and summing the
individual fields:

SELECT [Month], Sum(Tue), Sum(Wed),
Sum(Thu), Sum(Fri), Sum(Sar),
Sum(Total # Days), Sum(Monthly Sq. Ft.)
FROM MyQuery
GROUP BY [Month]



--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

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