Need something to replace OR statement

[cassie901]

Hi,

I need something to replace the OR in an IIF statement.

In otherwords, how can I simplify a statement such as

IIF(([state]= 'CA' or [state] = 'NY' or [state] = 'FL'),'big','small'). I suspect there is someway to use the in('CA','NY','FL') function but I haven't figured it out.

Thanks.

 

[cassie901]

Forgot to mention: I'm referring to MS Access.

Thank you.

 

[PHV]

In a query or a ControlSource, but not in VBA:
IIf([state] In ('CA','NY','FL'), 'big', 'small')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[cassie901]

Thank you.

I'm going to try it right now.