Using a query to search for data

  • Thread starter Thread starter LittyLou
  • Start date Start date
L

LittyLou

Hi

I have created a query that will search for a company name, however you have
to type the whole company name in order for it to show the data. How do I
make it so you only have to type part of the company name and it still finds
it or any other companies that have the same word in them?

Felicity
 
In the criteria row of your company name column put

Like "*" & [Enter Company Name or Part Company 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

Transposing data in Access 2007 Query 1
Query to select individual records 4
How to query a Dataset to Return Records that contain "a thing" 5
Filter using a Macro that runs a Query 1
Can Data from a Table Field be Used to Create Queries Automaticall 1
Query expression 1
Access Determine what query to run based on a checkbox 0
Filter a Query 1

Back
Top