Adding all to a combo box

[jderrig]

I have created a dialog box that allows me to select an
option button and then select an area that I want to
filter to a report. I would like to add ALL to the combo
box. Below is my select statement but I am not sure where
to put select <<ALL>>.


SELECT DISTINCT [Account Information].Area FROM [Account
Information] GROUP BY [Account Information].Area;

 

[Roger Carlson]

Try this:
SELECT "<<ALL>>" as Area FROM [Account Information]
UNION
SELECT DISTINCT Area FROM [Account Information]

Because you are using the DISTINCT clause, I don't think you need the Group
By.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L