Sum problem

[SReed via AccessMonster.com]

Hi all,

I have been searching this site and others for the answer to my problem but
so far none of the solutions work.

I am working with a preexisting database in which I have been asked to add a
total to the end of a report that already exists. I have placed an unbound
field in the Page Footer with the formula =Sum(myField) but I get #Error on
every page. When I add a Group Footer and place the field in it it gives me a
sum on every grouping. Any suggestions on what I am doing wrong or how to fix
this? I am using Microsoft Access 2003 to create the report.

 

[SReed via AccessMonster.com]

Well you can tell it has been 4 years since I have worked with Access. My
problem was that I was placing the field in the Page Footer when it needs to
be in the Report Footer.