How to fix Error when trying to write an if statement?

[carla siordia]

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")

[Rabbit]

I'm not sure what you're trying to do but here's how your IIf breaks out.

IIf(
[monthlyExtractorIPH]![KXT Rating]="Exceeds"
OR
[KXT Rating]="Me: IIf([monthlyExtractorIPH]![KXT Rating]="
Exceeds"
,
"3"
)

Here's how an IIf should be formatted.

IIf(
expression
,
trueValue
,
falseValue
)

[carla siordia]

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"

[Rabbit]

Your expression doesn't match your description at all. I see nothing in there about Meets or DNM. I see two Exceeds where the second Exceed is incorrectly syntaxed.

You also need to specify a false value, it's a required parameter of the IIf function.

[carla siordia]

Ok. I will try again. Thank You