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)"
 
Back
Top