Find CustomerName

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi ,

I am trying to create a query to find customer name by the first four digits
of the company name.It does not matter if similiar names appear, just
interested in the method for search.Is there a way to create a parameter to
do this search?
Thanks
 
Hi ,

I am trying to create a query to find customer name by the first four digits
of the company name.It does not matter if similiar names appear, just
interested in the method for search.Is there a way to create a parameter to
do this search?
Thanks
Click to expand...

As criteria for the CompanyName Field:

Like [What Company] & "*"

You're not limited to 4 characters. The more characters you enter, the
more restrictive the query will be.
 

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

Split CustomerName into First and Last 2
ODBC Pass-through query with parameter from table 5
Combine Data from Two Tables Options 3
Combo box select qry won't save in Row Source 1
Suppress duplicate CompanyName 2
Making a query that shows a value based on another value. 3
Checking if data exists another table and, if yes, extracting a value 0
Creating a Customer Rollup table 4

Back
Top