Add an ALL choice to a combo box

[XP]

Using Office 2003 and Windows XP;

I have a combo on a form with a SQL string in its RowSource. It works great,
but how can I change my SQL to include an "All" choice as the first item in
the drop down list?

For example, my SQL right now looks something like:

SELECT DISTINCT Dept1 FROM tblHeadCounts;

And yields: Accounting, Finance, Marketing, etc.

I want to include: ALL, Accounting, Finance, Marketing, etc.

Thanks in advance.

 

[Stefan Hoffmann]

hi,

I have a combo on a form with a SQL string in its RowSource. It works great,
but how can I change my SQL to include an "All" choice as the first item in
the drop down list?

For example, my SQL right now looks something like:

SELECT DISTINCT Dept1 FROM tblHeadCounts;

And yields: Accounting, Finance, Marketing, etc.

I want to include: ALL, Accounting, Finance, Marketing, etc.

Use a UNION query as row source:

SELECT "ALL" AS Dept1 FROM tblHeadCounts
UNION
SELECT DISTINCT Dept1 FROM tblHeadCounts



mfG
--> stefan <--