Formula Error

[bwlytkr]

Can someone help with an error I keep getting when I run my access query. I keep getting this error in the cells when I run my query. Below is the formula for the column and the results. Any help would be appreciated. Thanks

Potential Pull Pole Fee Charges: IIF([Potential Late Fees]="YES" And [Potential Pull Pole Fees]>1 And [DaysAged]>=60 ,"YES")

Potential Late Fees	Potential Pull Pole Fees	Potential Pull Pole Fee Charges	DaysAged
yes	$286.76	#Error	177
yes	$286.76	#Error	4883
yes	$286.76	#Error	3804

 

[Micron]

Maybe the query attempts to write the result to a field that will not accept Null (you didn't say what type of query this is) because your expression has no "value if False" part at the end. In that case any calculation that results in False returns Null as a result (or is it an empty string, I forget).
That's probably not it, but it's my first guess.

 

[petertenthije]

Another possibility is that the “potential late fees” field is a true/false field instead of a text field. In that case you would have to remove the quotation marks from your formula.

 

[Micron]

Another possibility is that the “potential late fees” field is a true/false field instead of a text field. In that case you would have to remove the quotation marks from your formula.

I think you nailed it. I'd suggest reviewing naming of Access objects (not only are they too long, the field names are full of spaces). Then there is DaysAged - looks like storing calculations, which is usually a no-no. Tomorrow, the value is out of date.

See also Microsoft Access tips: Problem names and reserved words in Access