Parameter Query

[nosaj_enryb]

All,

I have set up a parameter query but I was wondering if it is possible to
retrieve results when I only put in a part of the field.

e.g. Column one contains peoples full names. I want to do a search on this
using parameter queries that will display all names with 'John' in them. So
if I type in John when prompted by parameter, it will give me John Murphy,
John Smith, John Brown etc?

Is there anyway to do this without adding anpother field to my database>

Help would be great>

Jason

 

[Tom Ellison]

Dear Jason Byrne:

If you change the criterion from being "=" to "LIKE" then the user can add
wildcards. To search for first names of John the user could enter "John*"
or, better yet, "John *". If they enter "*John*" then it will find Johnson
as a last name as well. It is powerful, but can seem picky.

Tom Ellison