Report Footer Sum

  • Thread starter Thread starter Question Boy
  • Start date Start date
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
 
Is [Price] a numeric field in the report's record source? Is the control in
the Page Footer or the Report Footer.
 
Back
Top