Use a Criteria to search for part of a field

Porky

Registered User.
Local time
Today, 14:38
Joined
Jul 1, 2005
Messages
15
I want to ba able to search for only part of the field in a query. I want to run a reort from a query where the user only needs to enter part of the information from a product list ie the items listed may be as lisetd as make model in the same field. the user won't be able to get to the query to alter the criteria. i have tried:
Like "*" & [Enter Product Name] & Like "*" Which I found on a previous post but this returns a syntax error, and highlights the second Like
 
Rural Guy
Thanks works great now
 

Users who are viewing this thread

Back
Top Bottom