User Input Query

[Debbie L]

I would like to create a user input query where the user may not have the
exact name for a vendor. For example: a vendor's name in the database is
Mount Olympus Waters. I would like to search on "Olympus" or "water" and
then return the information I need.

 

[RonaldoOneNil]

In the criteria row of the vendor name column in your query put
Like "*" & [Enter Name or Part of Name] & "*"