QUERY CRITERIA

T

Tojib

Is there a way to set the criteria in a query to prompt the user to insert
part of a name and then have the query return all names with the specified
characters? For example, a vendor query. I now have the user enter the entire
vendor name or just hit enter (using IS NULL). Users don't always know the
exact vendor name so I would like to use partials if possible, understanding
that several results may be returned.
 
L

Lynn Trapp

LIKE "*" & [Enter Vendor Name] & "*"

This will return all results that match the string portion:

Entering "Joh" will return "John," "Johnson," "Johanssen," etc.
 
J

Jedit

Open the queryin design mod * set the criteria property to Like []
this will prompt for an input, if you do not know what you are looking for
then enter * & run the query. now you see a list showing all. If you know
half of the name i.e. entering ven* will show vendor, vendors & vending if
these are in your list
HOPE this helps
regards
Jed
 
Top