How do i find all items that have a certain word in using quiery

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my queries when i run it the dialog box says "Please enter the product
name"
How do i get it to find all products with only part of the name entered . So
say i entered the word red it would find all product with the word red in
 
Edwardo,

In your current query design, you must have a criterion on the product
name that li=ooks like:

[Please enter the product name]

You need to change this to:

Like "*" & [Please enter part of the product name] & "*"

So it will pick up all products with the inputted string anywhere in the
product name, beginning middle or end.

HTH,
Nikos
 
Back
Top