Part answers in parameter queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was wondering if it is possible to create a parameter query that prompts a
response from the user but only part of the data is needed to be inputted?
For example if you are asked for an employee's name and you enter Pete then
all the Pete's and Peter's etc will be found.
 
Dear Squid:

Instead of "=" in the criterion, use LIKE. You can either have the user add
wild cards (? for any one character, * for any one or more characters) or
you can add them for him with concatenation to his input string.

That should get it. If you have difficulty implementing this, please
respond with just how you want it to work.

Tom Ellison
 
Yes, and it's been answered below.

search for the topic:
"Can I use 'Like' or '*' operater is a parameter"
 
Back
Top