User Input Query

  • Thread starter Thread starter Debbie L
  • Start date Start date
D

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.
 
In the criteria row of the vendor name column in your query put
Like "*" & [Enter Name or Part of Name] & "*"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query - partial name 3
crazy query 5
Parameter Queries 2
Access Append Query Failure 1
Duplicates in union query 3
Select Query & Crosstab Query 1
query 2
Query Criteria not filtering out correctly 5

Back
Top