Second set of totals

  • Thread starter Thread starter Chris
  • Start date Start date
C

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
 
Chris said:
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.
Click to expand...


Add a group with a month footer. Use the same Sum
expressions you used in the week footer.
 
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?
 
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.
 
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?
Click to expand...
.
Click to expand...
 
Back
Top