DWUTKA at marlow.com
DWUTKA at marlow.com
Tue Apr 13 22:10:22 CDT 2004
SELECT "ALL" As AField FROM MyTable UNION SELECT MyField FROM MyTable Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Darren DICK Sent: Tuesday, April 13, 2004 10:02 PM To: AccessD List Subject: [AccessD] A2K:Adding the word ALL to a combo Hello all I need to add the word <ALL> to a combo SO pseudo = select * from MyTable and Then add "<ALL>" I have done this before through assistance from this list but I can't find the Gem or remember the dB I did it on :-(( Any suggestions? Many thanks Darren -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com