[AccessD] A2003:Adding All to a List

On 15 Nov 2004 at 16:24, Darren DICK wrote:

> So...
> If I want the text <ALL> to appear at the top of a legitimate list but it it
> not
> part of the recordset, how do I do it?
>  

Use a Union query:

Select "<ALL>"  as FirstName 
from tblNames
UNION
Select FirstName from tblNames
-- 
Stuart