I need help with a Total

[Val]

I have a report that gives me state and then line information. In the state footer I am doing a total for all lines within the state. How do I do a total for all states by line??

EX:
State 1 Line 1
State 1 Line 2
TOtal State 1

State 2 Line 1
State 2 Line 2
Total State 2

Total All States Line 1
Total All States Line 2
Total All States

Any suggestions appreciated. TIA

 

[Fornatian]

Assuming you are trying to sum one field(LINE) over a group(STATE), put an unbound control in the footer of the state and set it's controlsource to:

=Sum([Line])

Ian