Query - partial name

S

Steve

Hi...I have a program designed where we can input a specific vendor number,
and the query will pull up all the data related to that vendor. I would like
to have a query where the user can put in a PARTIAL vendor name, and the
program search for all records with those characters in the name. Does
anyone know how to do this???
 
K

KARL DEWEY

Use the Like function.
This one you enter the start of the name.
Like [Enter Vendor name] & "*"

This one you enter any part of the name.
Like "*" & [Enter Vendor name] & "*"
 
M

Marshall Barton

Steve said:
Hi...I have a program designed where we can input a specific vendor number,
and the query will pull up all the data related to that vendor. I would like
to have a query where the user can put in a PARTIAL vendor name, and the
program search for all records with those characters in the name.

The new query's criteria for the vendor name field would be
along these lines:

Like "*" & [Enter partial vendor name] & "*"

If you want to be able to enter either a venfor number or a
partial vendor name, put that on the OR line under the other
criteria.

If that's not close to what you need, post back with a more
detailed explanation of "where the user can put ..."
 
S

Steve

Thanks!

KARL DEWEY said:
Use the Like function.
This one you enter the start of the name.
Like [Enter Vendor name] & "*"

This one you enter any part of the name.
Like "*" & [Enter Vendor name] & "*"

--
KARL DEWEY
Build a little - Test a little


Steve said:
Hi...I have a program designed where we can input a specific vendor number,
and the query will pull up all the data related to that vendor. I would like
to have a query where the user can put in a PARTIAL vendor name, and the
program search for all records with those characters in the name. Does
anyone know how to do this???
 

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

Top