G
George Applegate
I would like to have the operator prompted for a "like" value. For
instance, I would like the operator to be prompted to enter the word
PUSH if the description field contains PUSH anywhere in the
description.
This is a query using microsoft query which returns data to excel.
For normal parameter queries you enter in the criteria something like
[Enter value to search for]. That works on queries for "equal"
conditions, but I can't figure out how to prompt for a "Like"
condition that I want the user to be able to enter the parameter for.
For instance I think I need to enter something like:
Like "'%"[Enter value to search for]"%'" but that doesn't seem to
work. I could write this in the SQL native if someone could give me an
idea how to do that too, since the query criteria eventually gets
generated into SQL anyway.
Can anyone help me? This is a unique situation because of the LIKE
and wild-card symbols.
thanks,
ga
George Applegate
(e-mail address removed)
instance, I would like the operator to be prompted to enter the word
PUSH if the description field contains PUSH anywhere in the
description.
This is a query using microsoft query which returns data to excel.
For normal parameter queries you enter in the criteria something like
[Enter value to search for]. That works on queries for "equal"
conditions, but I can't figure out how to prompt for a "Like"
condition that I want the user to be able to enter the parameter for.
For instance I think I need to enter something like:
Like "'%"[Enter value to search for]"%'" but that doesn't seem to
work. I could write this in the SQL native if someone could give me an
idea how to do that too, since the query criteria eventually gets
generated into SQL anyway.
Can anyone help me? This is a unique situation because of the LIKE
and wild-card symbols.
thanks,
ga
George Applegate
(e-mail address removed)