Queries with Wildcards

F

Fred

I want to make a Query on a text field that Prompts me
for a name (Say Bob) and searches for wildcards
automaticly. So it would pull Bob, Bobby, etc.. How
hard would something like this be to do?
 
J

John Vinson

I want to make a Query on a text field that Prompts me
for a name (Say Bob) and searches for wildcards
automaticly. So it would pull Bob, Bobby, etc.. How
hard would something like this be to do?
Click to expand...

Use a criterion of

LIKE [Enter name:] & "*"

The user will be prompted, and the asterisk will serve as your
wildcard.
 
Top