How can I sum several different fields in an Access report?

  • Thread starter Thread starter dahlia
  • Start date Start date
D

dahlia

Can I sum values from more than one field in an Access report? If so, how
can I do so?
 
Sure can - if the fields are in the detail section. In the report footer,
or a group footer, place an unbound textbox and set its controlsource to an
expression such as:
=Sum([Field1]) + Sum([Field2])

If the control is in a group footer, it will give the sum for that group
only; if it's in the report footer, it will give the overall sum.

HTH,

Rob
 
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

want to add sum fields in different sections of a report 1
Access count a field in access report 2
Sum in Report Errors 3
Report Sums of Sums 1
Report Footer Sum 1
Sum in report 10
how can I caclulate the sum of a sum in a report? 2
Report Sum with Multiple Relationships 2

Back
Top