Find CustomerName

J

jk

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
 
F

fredg

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.
 
Top