SubTotals in Access Report

  • Thread starter Thread starter Elizabeth.coleman
  • Start date Start date
E

Elizabeth.coleman

Hello,
Can someone tell me how to add subtotals to my report in
Access?
 
Go to Sorting and Grouping and group on a field that groups your data to be
able to get the subtotals you want. You will get a Group Header in your
report. Click on the Group Header to get its properties. Set Group footer to
Yes . Add a textbox named Subtotal in the Group Footer and set its control
source to:
=Sum([NameOfFieldYouWantSubtotalFor])
Put a textbox named Grand Total in the report's footer and set its control
source to:
=Sum([Subtotal])
 
You must log in or register to reply here.

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

Similar Threads

calculating Subtotals in Access Reports but under certain criteria. 5
Conditional query/report 0
Access Subtotal in Query 3
Average of Subtotals in Pivot Table 0
grouping for subtotals 4
Access Microsoft Access - Subtotals for each page 0
Subtotal Queries within 3
Conditional SUBTOTAL in XL210 Table 7

Back
Top