Queries with Wildcards

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

 

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

Use a criterion of

LIKE [Enter name:] & "*"

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