Parameters - return all records when null

[Gary B]

Following is a really cool query I found that allows the passing of a
parameter, and if it is null, it returns all the records. I can not figure
out how to do the same thing when passing more than one parameter (against
different fields).

SELECT Orders.OrderID, Orders.CustomerID, Orders.OrderDate,
Orders.ShipCountry
FROM Orders
WHERE ((([Enter the country: Example: 'USA']) Is Null)) OR
(((Orders.ShipCountry)=[Enter the country: Example: 'USA']) AND (([Enter the
country: Example: 'USA']) Is Not Null));

 

[Van T. Dinh]

Actually, it is NOT cool: there is a redundant criterion in the WHERE
Clause.

The following SQL should work exactly the same:

SELECT Orders.OrderID, Orders.CustomerID, Orders.OrderDate,
Orders.ShipCountry
FROM Orders
WHERE ((([Enter the country: Example: 'USA']) Is Null))
OR (((Orders.ShipCountry)=[Enter the country: Example: 'USA']));

You can do similarly for criteria on other Fields.