Total Amount to be shown on Report

  • Thread starter Thread starter buck
  • Start date Start date
B

buck

I have a field named 'Amount'; I can get a total amount
using a query--but don't know how to make a total for the
Amount column show on a report.

Amount
$20.00
$30.00


Would like to have column reflect a total.
Your assistance would be appreciated. Thanks
 
buck said:
I have a field named 'Amount'; I can get a total amount
using a query--but don't know how to make a total for the
Amount column show on a report.

Amount
$20.00
$30.00


Would like to have column reflect a total.
Your assistance would be appreciated. Thanks

Use Sorting and Grouping; group on some field; display footer for this
group; in the footer, have a control with controlsource "=sum(amount)"
 

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

Back
Top