Total in Access report

L

Lacy

How can I have a calculation based on the RESULT of the columns generated in
an Access report? For example:

Utilities Rent Total
Martha 10.00 5.00 15.00
John 5.00 5.00 10.00
Peggy 10.00 10.00 20.00
Total 25.00 20.00 ? <--- here is where I can't
figure out in the expression builder to give me a total of the total column.

Please help!
Thank you,
Lacy
 
W

Wayne Morgan

Try a control source of

=[txtUtilitiesTotal] + [txtRentTotal]

where txtUtilitiesTotal is the name of the textbox at the bottom that has
the 25.00 and txtRentTotal is the name of the textbox at the bottom that has
the 20.00.
 
Top