Query - partial name

[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???

 

[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] & "*"

 

[Marshall Barton]

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

 

[Steve]

Thanks!

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

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???