How to skip a query parameter to view all details.

[Guest]

I have a query with parameters to filter some details, but somtimes I want
to view all details.

 

[Guest]

Use this for your parameter ---
Like [Enter parameter] & "*"
It will use the wildcard when you press the ENTER key without typing
anything at the prompt.

 

[Guest]

Test for each parameter being NULL within parenthesised Boolean OR
expressions, e.g.

SELECT *
FROM Customers
WHERE (State = [Enter State:] OR [Enter State:] IS NULL)
AND (City = [Enter City:] OR [Enter City:] IS NULL);

If no value is entered for a parameter the parenthesised expression will
evaluate to TRUE for every row by virtue of the parameter being NULL, if a
value is entered for the parameter it will only evaluate to TRUE where the
value in the column matches the value entered, so the result will be
restricted to those rows.

Ken Sheridan
Stafford, England

 

[Guest]

Thanks a lot Ken, I have tested this and it worked.
M.A.Halim

Test for each parameter being NULL within parenthesised Boolean OR
expressions, e.g.

SELECT *
FROM Customers
WHERE (State = [Enter State:] OR [Enter State:] IS NULL)
AND (City = [Enter City:] OR [Enter City:] IS NULL);

If no value is entered for a parameter the parenthesised expression will
evaluate to TRUE for every row by virtue of the parameter being NULL, if a
value is entered for the parameter it will only evaluate to TRUE where the
value in the column matches the value entered, so the result will be
restricted to those rows.

Ken Sheridan
Stafford, England

I have a query with parameters to filter some details, but somtimes I want
to view all details.