gotta be something simple i'm missing

[dotolee]

I've created a report and i'm trying to tally up a few numbers. some fields work, some don't.
Odd thing is that for the fields that don't add up - i'm also being prompted for a value by the system when i initially run the report.... which i'm just hitting enter through. but my guess is that these problems might be related??
why does this happen?
Sample code:
=Sum(IIf(Not IsNull([12Exclusion]),1,0))

 

[PHV]

i'm also being prompted for a value
What is the wording of the prompt ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dotolee]

BINGO! Found it.. sorry for the trouble PHV.
found an article on line that tipped me off..
cheers.

article:

If a report prompts for unexpected parameters, make sure that all field names used in the following areas
of the report's design are spelled correctly and match field names in the underlying table or query:
· ControlSource property of any controls.
· Field/Expression column in the Sorting And Grouping box.
· Expressions in controls or in the Sorting And Grouping box.