Second set of totals

[Chris]

I've created a report that groups daily sales data and
sums by week under group footer. When I try to sum the
entire month of sales at the page footer, I get an error
message. Can anyone help me with creating a report that
has each day of sales, plus two sets of totals: week-end
and month-end? The query the report is pulling data from
has the daily sales totals.

thanks,
chris

 

[Marshall Barton]

I've created a report that groups daily sales data and
sums by week under group footer. When I try to sum the
entire month of sales at the page footer, I get an error
message. Can anyone help me with creating a report that
has each day of sales, plus two sets of totals: week-end
and month-end? The query the report is pulling data from
has the daily sales totals.

Add a group with a month footer. Use the same Sum
expressions you used in the week footer.

 

[Chris]

Thanks, I did this (under "Sorting and Grouping" I
grouped one on "week" and one on "month") but both are
producing weekly totals.

any thoughts on where I'm going wrong?

 

[Marshall Barton]

It sounds like you added the month group under the week
group, it needs to be above the week group in the Sorting
and grouping window.

 

[Chris]

That was it- Thank you!

-----Original Message-----
It sounds like you added the month group under the week
group, it needs to be above the week group in the Sorting
and grouping window.
--
Marsh
MVP [MS Access]

Thanks, I did this (under "Sorting and Grouping" I
grouped one on "week" and one on "month") but both are
producing weekly totals.

any thoughts on where I'm going wrong?

.