ERROR in formula and Paramter Values

[nwood]

Hi All,



I have been working on query and have run into a few problems.

First, I have deleted certain calculated fields in my query, but every time I launch my query, dialog boxes pop up asking me to enter parameter values for these deleted fields. How can I prevent these dialog boxes from popping up?

Also, I am having a problem with an iif formula. In datasheet view, I get #ERROR in the column of this field. The formula is listed below...

USP < USCP Last 12 Months: IIf([TotalValue]=0,0,IIf([ACCRUAL_or_NOT]=0,0,IIf([%ProvisionCalculated]<0,IIf([%ProvisionCalculated]<-1,-1,[%ProvisionCalculated]),0)))

Any help would be greatly appreciated!

[JoeM]

Do you have a "<" in the name of this calculated field? That could be causing issues.
You should really avoid using special characters like "<" in variable or field names, and "%" too (especially starting field names with those characters).
Recommend naming of objects, fields, variables, etc is to just use numbers, letters, and underscores (you are even encouraged NOT to use spaces).