how do I total a column in access

J

jrmerriwa

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?
 
D

Dennis

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])
 
Top