A
AccessMan
I am trying to use a parameter query to narrow query results. On the
criteria line I have entered [Enter field criterion:] which prompts the user
for a value.
However, I would like the criterion to be treated as "Is Not Null" when the
user does not enter anything for the parameter, i.e., when they just hit
enter. Using Like "*"&[Enter field criterion:]&"*" accomplishes this, but it
also can return more results than what I want. When a query parameter is
entered, I want an exact match. When nothing is entered I want all results.
I've tried fooling with temporary variables, but can't get it to work. Any
ideas? Thanks!
criteria line I have entered [Enter field criterion:] which prompts the user
for a value.
However, I would like the criterion to be treated as "Is Not Null" when the
user does not enter anything for the parameter, i.e., when they just hit
enter. Using Like "*"&[Enter field criterion:]&"*" accomplishes this, but it
also can return more results than what I want. When a query parameter is
entered, I want an exact match. When nothing is entered I want all results.
I've tried fooling with temporary variables, but can't get it to work. Any
ideas? Thanks!