Hide "All" from query 1

[TimTDP]

I Access 2000, I have the following SQL statement for a conbo box:
SELECT DeliveryDriverId, DeliveryDriver FROM qryDrivers UNION SELECT Ast, Desc FROM tblAsterisk
ORDER BY DeliveryDriver;

If qryDrivers contains no records, the combo box still returns the Ast, Desc FROM tblAsterisk.

What is the correct syntax to have NO records returned by the combo box if qryDrivers doesn't contain any records?

 

[PHV]

You may try this:
SELECT DeliveryDriverId, DeliveryDriver FROM qryDrivers UNION SELECT Ast, Desc FROM tblAsterisk WHERE EXISTS(SELECT * FROM qryDrivers) ORDER BY 2

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886