Adding all to a combo box

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;

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/...UBED1=ACCESS-L


"jderrig" wrote in message
...
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;