S
Silvio
In short, if tbl2 have some value in it, retrieve only the matching records
in tbl1 otherwise, if tbl2 is empty then retrieve all the records from tb1.
This is what I have done, but if I live the control empty from the form, no
records are retrieved at all, ignoring the "is null". Please help. In short,
if tbl2 have some value in it, retrieve only the matching records in tbl1
otherwise, if tbl2 is empty then retrieve all the records from tb1.
SELECT tblData.City
FROM tblData
WHERE (((tblData.City) In (SELECT city FROM tblRepCity) Or (tblData.City) Is
Null));
in tbl1 otherwise, if tbl2 is empty then retrieve all the records from tb1.
This is what I have done, but if I live the control empty from the form, no
records are retrieved at all, ignoring the "is null". Please help. In short,
if tbl2 have some value in it, retrieve only the matching records in tbl1
otherwise, if tbl2 is empty then retrieve all the records from tb1.
SELECT tblData.City
FROM tblData
WHERE (((tblData.City) In (SELECT city FROM tblRepCity) Or (tblData.City) Is
Null));