A
Ayse via AccessMonster.com
I have a query with multiple calculated fields. I need to return a value
of 0 if [RichCalc2a] = 5774 otherwise I want it to display the field value.
I have tried the following statement
IIf([RichCalc2a]=5710,0,[RichCalc2a])
but two parameter windows popup asking for RichCalc2 and RichCalc2A.
Any help would be great!
of 0 if [RichCalc2a] = 5774 otherwise I want it to display the field value.
I have tried the following statement
IIf([RichCalc2a]=5710,0,[RichCalc2a])
but two parameter windows popup asking for RichCalc2 and RichCalc2A.
Any help would be great!