Syntax help on an Expression

[spacekowboy]

Hi, I have the following expression:



ClaimAmtDue: IIf(TblMasterClaimsRecord![Claim Number] Like "14*","$200","$350")

I also need the following incorporated into the expression but having trouble:

if Type of Loss = "RPT" then $100 else $350

Any help would be appreciated

[rpeare]

incorporated into the same expression?

so the type of loss is only relevant if the claim number DOES NOT start with 14?

you'd have to have a nested iif like this:

ClaimAmtDue: IIf(TblMasterClaimsRecord![Claim Number] Like "14*","$200",(iif([type of loss] = "RPT", "$100", "$350")))

[spacekowboy]

Actually the "type of loss" will always be relevant

Thanks

[rpeare]

I don't know what that means.

You've introduced two variables with two different results each

1. Claim number (the two results are starts with 14 and doesn't start with 14)
2. Type of Loss (the two results are the value is RPT or the value isn't RPT)

in essence you have four possible outcomes (two variables with 2 possible results each)

so what do you want your formula to result in for each possible outcome?

[spacekowboy]

if "14" = $250
if "RPT" = $100
anything else = $350

Thanks

[June7]

So should test for "14" first? That takes precedence over "RPT"?

rpeare's suggestion in post 2 does that.

Is it 200 or 250?

[spacekowboy]

So far it looks like this will work!
ClaimAmtDue: IIf(TblMasterClaimsRecord![Claim Number] Like "14*","$200",(iif([type of loss] = "RPT", "$100", "$350")))

Many thanks rpeare
and June7