Total in Access report

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top