Summarizing in footer... need help! 2

[Trogg]

Hello,

As an example let's say I have query that produces these results for one person:

Name Days Money
Bill 0 10
Bill 2 20
Bill 0 50
Bill 1 30
Bill 3 40

The report is sorted and grouped by Name with a header and footer for each Name. In the footer I would like to see something like this:

Totals: 0 Days = 2 Days > 0 = 6
Money: 60 90

How can I do this on the report? Or is there a better way to break it up in the query first? Thanks in advance.

 

[dhookom]

To get the count of the Days field with values = 0, create text boxes with:
[tt][blue]
Control Source: =Sum(Abs([Days]=0))
Control Source: =Sum([Days])
Control Source: =Sum(Abs([Days]=0) * [Money])
Control Source: =Sum(Abs([Days]>0) * [Money])

[/blue][/tt]

Duane
Hook'D on Access
MS Access MVP

 

[Trogg]

Thanks Duane! That was perfect... ws also able to modify it a bit for another issue that was bugging me! Star for you sir!

 

[Lhuffst]

Thanks Duane! I have been struggling with why my sum wasn't working all morning and you had the answer!
Lhuffst