how do I total a column in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a total column of the total of 2 columns I wish to Grand total the
total column at the end of a report. Sum doesnt seem to work in a footer. can
anyone give me the correct expression?
 
Sum is the correct syntax and it does work in a footer section. You must have
an = sign before it

=Sum([FieldName])
or
=Sum([Quantity] * [UnitPrice])
 
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

CrossTab Group Totals 1
Wrong Sum in Report Footer 2
Grand Total for a calculated column - Access 2007 1
Totaling An Aggregate Expression On A Report 4
How to Sum Two Sums in Report 2
Excel Subtracting multiple columns from another column 3
How do I add a calcalated column in a table using other columns? 1
2 columns reports set up and report footer 1

Back
Top