Totals by date on report footer

[Guest]

I have a report that is designed like this:
Location Header:3 Locations
Detail: By Date
Mon
Tue
Wed
Thur
Fri
Location Footer: Totals by location
Report Footer: Total for all locations by date
Mon
Tue
Wed
Thur
Fri

I cannot get the report footer to give me totals by date. It gives me grand
totals, but it will not give me totals by date. What can I do to get these
here?

 

[Marshall Barton]

I have a report that is designed like this:
Location Header:3 Locations
Detail: By Date
Mon
Tue
Wed
Thur
Fri
Location Footer: Totals by location
Report Footer: Total for all locations by date
Mon
Tue
Wed
Thur
Fri

I cannot get the report footer to give me totals by date. It gives me grand
totals, but it will not give me totals by date. What can I do to get these
here?

In most situations like this, you're better off creating a
subreport based on a Totals (Group By) type query.

SELECT DatePart("w", datefield), Sum(amountfield)
FROM thetable
GROUP BY DatePart("w", datefield)

If that's too much trouble when you have only a few separate
totals, then you could use 5 text boxes with expressions
like:
=Sum(IIf(DatePart("w", datefield) = 2, amountfield, 0))