I need help with Immediate If Function

[Talismanic]

I have an Immediate If that looks like this:

GetValue: IIf([extrate]>[pwrate], [extrate],[pwrate])

Is there a way to throw another condition in this query? I would like to evaluate another field that will have either a 1, 2 or 3 in it. So I would need to incorporate a AND/OR into this GetValue. Is this possible?

If that doesn't make sense, let me try it this way:


If OtherField has 1 or 2 do GetValue if it has a three, ignore the GetValue ImediateIF Function and place a null or at the very least a 0 in the GetValue field.

 

[Talismanic]

I am missing soemthing because I am getting an error that says the Expression you entered has a function with the wrong number of arguments.

GetValue: IIf([EarnCode]=1 or [EarnCode]=2), IIf([extrate]>[pwrate], [extrate],[pwrate]),0)

Do you see anything wrong with the way I am doing it?

 

[Chris RR]

My guess is another set of parentheses (spelling???). Try this:

GetValue: IIf(([EarnCode]=1 or [EarnCode]=2), IIf([extrate]>[pwrate], [extrate],[pwrate]),0)

 

[Talismanic]

That fixed it, thanks to both of you!!!

 

[cfmiles]

I don't post much... and here is why. I thought I'd share for anyone new coming out here. I use the search feature before I do anything else - and was racking my brain with a nested iif function, trying to figure out how I could possibly be messing it up. This "old" post lit a lamp in my brain and I have the problem solved.

Thanks - belatedly - for all of the help this forum provides.

 

[BukHix]

cfmiles, I am he, formaly know as Talismanic and I gotta agree with you there. I just love the search feature and can usually find about 90% of everything I am looking for with it.