Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by cassie901
-
Need something to replace OR statement
Thank you. I'm going to try it right now.- cassie901
- Post #4
- Forum: Microsoft: Access Other topics
-
Need something to replace OR statement
Forgot to mention: I'm referring to MS Access. Thank you.- cassie901
- Post #2
- Forum: Microsoft: Access Other topics
-
Need something to replace OR statement
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
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
