Sum total for detail by group

G

George

Hi,
I have a report that has 2 grouping sections:
1 = date header and
2 = account header
I would like to sum the [Market values] in the detail section by the account
header. So i want the Sum([Market Values]) by account name
Am i making sense?
Please help.
Thanks
George
 
D

Duane Hookom

Add a text box in your Account Header group header or footer section with a
control source of:
=Sum([Market Values])
This assumes you have a field in your report's record source named [Market
Values].
 
G

George

Thanks Duane that worked a treat

Duane Hookom said:
Add a text box in your Account Header group header or footer section with a
control source of:
=Sum([Market Values])
This assumes you have a field in your report's record source named [Market
Values].


--
Duane Hookom
MS Access MVP

George said:
Hi,
I have a report that has 2 grouping sections:
1 = date header and
2 = account header
I would like to sum the [Market values] in the detail section by the
account
header. So i want the Sum([Market Values]) by account name
Am i making sense?
Please help.
Thanks
George
Click to expand...
Click to expand...
 
Top