Total in Access report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top