Using a query to search for data

[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

 

[RonaldoOneNil]

In the criteria row of your company name column put

Like "*" & [Enter Company Name or Part Company Name] & "*"