iif statement

[ChristopherL]

Hi, I am having some trouble with an iif statement as selecting the field..
I have two columns, one called [sdCounterpartyprice] and one called [bid]

I want to select the [bid] if it's not equal to Null or 0, if it is equal to that then pick [sdCounterpartyprice]

this doesn't work

CptyPrice: IIf ([bid] is null or = 0; [sdCounterpartyprice]; [bid])

 

[pr2-eugin]

Try..

CptyPrice: IIf (IsNull([bid]) Or [bid] = 0; [sdCounterpartyprice]; [bid])

 

[ChristopherL]

Try..

CptyPrice: IIf (IsNull([bid]) Or [bid] = 0; [sdCounterpartyprice]; [bid])

Thank you sir!

 

[pr2-eugin]

Just remember each condition has to be tested separately.. Glad to help..