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

Yes I did
Thanks
I actually wanted the < and the > in the appearance of the word in the list
Thanks heaps Gustav

This list is way cool. :-)))

----- Original Message ----- 
From: "Gustav Brock" <gustav at cactus.dk>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Wednesday, April 14, 2004 6:50 PM
Subject: Re: [AccessD] A2K:Adding the word ALL to a combo - SOLVED


> Hi Darren
> 
> > Thanks to all who responded
> > I went with Drew's suggestion
> > 'Cause he was first :-))
> 
> Yeah, but I guess you did adjust it to use "<ALL>", because "ALL"
> could be sorted within your recordset. Thus, if you have Alice and
> Susan, your combo would list:
> 
>      Alice
>      ALL
>      Susan
> 
> /gustav
> 
> > SELECT "ALL" As AField
> > FROM MyTable
> >
> > UNION SELECT MyField
> > FROM MyTable
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com