In a query I have a calculated field that I want to look at field [FEE SCHEDULE]![OFF] and if it does not equal 0.00 return ([FEE SCHEDULE]![OFF] but if it equals 0.00 return [SC 85%]. I have it written as:
SC: IIf([FEE SCHEDULE]![OFF]<>"0.00",[FEE SCHEDULE]![OFF],IIf([FEE SCHEDULE]![OFF]="0.00",[SC 85%]))
But all I get is #ERROR. How should I be writing this to return the correct responses?
Thank you!