Multiple LIKE statements
Hello Programmer Gurus!
I am trying to query my databsse of 10 ten fields for a search page.
When I use:
Model1 like '" & Search & "%' AND Model2 like '" & Search & "%'AND AND Model2 like '" & Search & "%'
I only get results from the first like statement. I know I have matching criteria in the other fields. any ideas??
|