Sum All Field

G

Guest

I have a report that lists each person and the number of scans that they did
on any given range of days. The current calculation is =Sum([#ofimages])

At the end of the report I would like to see a total for everyone, how do I
build this calculation?
 
G

Guest

On the Report Footer create a text box and use the same Sum

=Sum([FieldName])

If you want to add more then one field
=Sum([FieldName] + [FieldName2])

Or
=Sum([FieldName]) + Sum([FieldName2])

Note: the field name should be the name of the fields in the table, and not
the names of the text boxes in the report
 

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