summing data/using sections correctly

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hello,

I am new to Access and am trying to build reports off of
queries that have already been set up for me. My question
is Im having trouble summing my data in the page footer.
The formula Im using is "Sum=[(What Im summing)]" and when
I run it I get a #error.

Could my queries be wrong or is it a more simple fix?

Thanks.
 
Page footers are not designed for collecting totals.

Would it be possible to use a group footer instead? (See the Sorting And
Grouping box, from the View menu.)

If not, you can do it programmatically, as described in this article:
Reports: Page Totals
at:
http://allenbrowne.com/ser-11.html
 
I'm a newbie, but a couple of ideas. (1) When you make
the report (using report wizard), just after the grouping
choices, you should have summary options (you may have to
put in a sort order) and be able to sum as a choice. (2)
From looking at something very similar I believe it should
be =sum([What Im summing])
This may help some, but why the #Error? Please let me
know if this works at all. Thank you.
 
Back
Top