Second set of totals


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
 
Ad

Advertisements

M

Marshall Barton

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.

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

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?
 
M

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.
 
Ad

Advertisements

C

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?
.
 

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

Similar Threads

Totals showing up on second page 1
2 Sets of Totals 3
Trying to total minutes and seconds stored in text field 3
Total of Totals 2
Group Totals and Totals 0
Totalling a total column 1
totals 1
Totals 1

Top