If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How a multiparameter query returns all records if all r null?
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. |
#2
|
|||
|
|||
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) -- Brendan Reynolds (MVP) "INM" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Query returns more multiple entries - Records can't be identified | SAm | General Discussion | 2 | July 29th, 2005 10:37 PM |
Moving from xBase/Clipper | [email protected] | New Users | 1 | February 3rd, 2005 07:25 PM |
adding 2 fields including null entries | Jesse | Running & Setting Up Queries | 26 | January 18th, 2005 05:31 PM |
count number of records | Joe_Access | General Discussion | 1 | January 13th, 2005 06:27 PM |
One query that returns records by each fiscal year | Arkie | Running & Setting Up Queries | 6 | January 7th, 2005 06:39 PM |