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

Totalling Expr1 in a report 1
how can I caclulate the sum of a sum in a report? 2
Sum of sub-form/sub-report 10
Partial Report footer sum 1
Report Calculation 2
Sum unique entries in report footer 2
sum error 2
Total not correct in Footer 1

Top