Wild card in parameter

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

Guest

This may sound simple to you all, but it has me stymied. I need to give
people the ability to search a query for somthing starting with say q*. I
can do it in my underlying query, but they are looking at reports so if they
put in q* in my parameter pop up when they run the report they get nothing.
I am sure it's something simple but not sure how to do it.
 
Dear Akrt:

It's hard to tell. If you'll post the SQL of the query you have and tell us
what the user types, and what values in the database you expect it to match,
likely someone will be able to figure out something.

Tom Ellison
 
This may sound simple to you all, but it has me stymied. I need to give
people the ability to search a query for somthing starting with say q*. I
can do it in my underlying query, but they are looking at reports so if they
put in q* in my parameter pop up when they run the report they get nothing.
I am sure it's something simple but not sure how to do it.
Click to expand...

Use a criterion of

LIKE [Enter search term:] & "*"

The default = operator does not recognize wildcards; the LIKE operator
does. The above will prompt the user, and if they type "q" in
response, it will generate a list of all the records where this field
begins with q.

John W. Vinson[MVP]
 
Thank you John, I knew it was something I did not get. Works like a charm!


John Vinson said:
This may sound simple to you all, but it has me stymied. I need to give
people the ability to search a query for somthing starting with say q*. I
can do it in my underlying query, but they are looking at reports so if they
put in q* in my parameter pop up when they run the report they get nothing.
I am sure it's something simple but not sure how to do it.
Click to expand...

Use a criterion of

LIKE [Enter search term:] & "*"

The default = operator does not recognize wildcards; the LIKE operator
does. The above will prompt the user, and if they type "q" in
response, it will generate a list of all the records where this field
begins with q.

John W. Vinson[MVP]
Click to expand...
 
Back
Top