[AccessD] A2K:Adding the word ALL to a combo

Howdy
Thanks for the reply
Excellent
DD
----- Original Message ----- 
From: <DWUTKA at marlow.com>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, April 14, 2004 1:10 PM
Subject: RE: [AccessD] A2K:Adding the word ALL to a combo


> 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
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com