[AccessD] Adding "All" to Combo List

One way is something like this :

SELECT ID, Descr 
	FROM Project
UNION 
SELECT 0 as t1,'(All)' as t2
     	FROM Project " & _
   "ORDER BY Descr ASC;"

The UNION statement is the key here.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris
Fields
Sent: Monday, February 06, 2006 10:23 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Adding "All" to Combo List


Hi,

I know I saw something about how to do this discussed on this list.  How 
do I add the "All" indication at the top of a combobox list?  Thanks.

Tina