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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using IIF and OR
A follow-up question: I'm trying to do the same query but need to use a wildcard, in other words my fields aren't just filled with A or B and C but with A01 or A19 or B01 or B02, etc. I thought the asterisk would work as a wildcard, i.e.: IIf(x='A*' OR x='B*' OR x='C*', True, False) ... but...- linsk33
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
