Calculation issues Access 2003

[dawnd3]

Hi there, I am trying to do a calculation in a report but it keeps throwing up the "Enter Parameter Value" like it doesn't recognize the field. I created a field in the detail section called "TotalOrder" and this has a calculation that works great. I then have another field in the group footer using that field in the calculation and it doesn't seem to be working.

Here is my group footer calculation:

=Sum([CountofPsilosSource])-Sum([TotalOther])

[CountofPsilosSource] being another field in the report and is being summed in another footer field just fine. [TotalOther] is the field I created and yet it doesn't know what it is.

Can you help?

Dawn

 

[marieannie]

Hi, Can you check the names of the fields?
TotalOther or TotalOrder??

I don't know if you mispelled them just in the message

Regards

 

[dawnd3]

good catch. THey are both "TotalOther" I just misspelled in the message.

Dawn

 

[dawnd3]

nevermind I figured it out. I guess the report doesn't like me using the field name in the footer calculations since the field was just created in the report, so I needed to put in the actual detail calculation instead and that worked.