Queries with Wildcards

  • Thread starter Thread starter Fred
  • Start date Start date
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?
 
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.
 
Back
Top