Using a query to search for data

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
 
R

RonaldoOneNil

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

Filter using a Macro that runs a Query 1
Transposing data in Access 2007 Query 1
Query expression 1
How to query a Dataset to Return Records that contain "a thing" 5
Query to select individual records 4
Combine the contents of a field so only one row is displayed 1
How do I query companies not having members w/certain level of mgm 5
Query showing unexpected results 5

Top