[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