How a multiparameter query returns all records if all r null?

I

INM

How can I make a multi-parameter query returns all records if none of the
parameters is specified? What the help suggests works only if the query has
only one parameter. Thanks.
 
B

Brendan Reynolds

PARAMETERS [TestID?] Long, [TestText?] Text ( 255 ), [TestNum?] Long;
SELECT tblTest.TestID, tblTest.TestText, tblTest.TestNum
FROM tblTest
WHERE (((tblTest.TestID)=[TestID?])) OR (((tblTest.TestText)=[TestText?]))
OR (((tblTest.TestNum)=[TestNum?])) OR ([TestID?] IS NULL AND [TestText?] IS
NULL AND [TestNum?] IS NULL)
 
Top