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] & "*"
 
Back
Top