carla siordia
Joined: Jan 31 '11
Location:
-
Ok. I will try again. Thank You -
I think the issue is I am not looking for a false value. I am looking for a true for 3 different senarios.
so IIf(
[monthlyExtracto rIPH]![KXT Rating]="Exceeds" then "3"
IIf(
[monthlyExtracto rIPH]![KXT Rating]="Meets" then "2"
IIf(
[monthlyExtracto rIPH]![KXT Rating]="DNM" then "1"Leave a comment:
-
How to fix Error when trying to write an if statement?
I am receiving an error
Numeric Numeric Rating: IIf([monthlyExtracto rIPH]![KXT Rating]="Exceeds" OR [KXT Rating] ="Me: IIf([monthlyExtracto rIPH]![KXT Rating]="Exceeds"," 3")
No activity results to display
Leave a comment: