query criterion management

[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!

 

[Guest]

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!

Use the following as your criteria:

[Enter field criterion:] Or [Enter field criterion:] Is Null

John

 

[AccessMan]

John:

This worked perfectly! Thanks!

So getting the criteria to evaluate to true in the event of a null response
is what I needed to do? This was not obvious to me beforehand.

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!

Use the following as your criteria:

[Enter field criterion:] Or [Enter field criterion:] Is Null

John