Wild card in parameter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Akrt48 - 23 Mar 2006 01:36 GMT

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.

Reply to this Message

Tom Ellison - 23 Mar 2006 01:47 GMT

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
[quoted text clipped - 3 lines]
> nothing.
> I am sure it's something simple but not sure how to do it.

Reply to this Message

John Vinson - 23 Mar 2006 01:50 GMT

>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.

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]

Reply to this Message

Akrt48 - 23 Mar 2006 01:58 GMT

Thank you John, I knew it was something I did not get. Works like a charm!

> >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
[quoted text clipped - 12 lines]
>
> John W. Vinson[MVP]

Reply to this Message