Report Footer Sum

Q

Question Boy

I am using Access 2000 to build, what I thought was, a simple report. It
list each entry (financial) and I then added in the report footer a field to
calculate the sum

=Sum([Price])

In Access 2003 and 2007 this work fine, but in 2000 it spits out an error
about not being able to calculate the expression..... How can I calculate a
sum of all the records and display it in the report footer? I messed around
with the running sum, but that does not give me what I need.

QB
 
D

Duane Hookom

Is [Price] a numeric field in the report's record source? Is the control in
the Page Footer or the Report Footer.
 

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

Access form continuous 1
Report Group Footer DLookUp 0
Calculating overtime in report footer 2
A03 - count in report footer gives me #Error? 0
Totalling Expr1 in a report 2
Sum of sub-form/sub-report 6
Cumulative formula for word table 0
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9

Top