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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help with query - want to search on 2/3's of a field.
that works! thanks for the help- jeff3448
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Help with query - want to search on 2/3's of a field.
i am having a similar problem but i want to use Like operators as the return expressions in a SQL iff expression my code looks like iif(forms![runreport]![A] = -1 , (info.module) like "1756-I*" , (info.module) like "1756-O*" ) Where A is a check box in a form that runs a report when I use...- jeff3448
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
