Darren DICK
d.dick at uws.edu.au
Mon Nov 15 00:31:31 CST 2004
Hi Stuart As usual - You Da Man!!!!!!!!! Many thanks Darren -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Monday, 15 November 2004 4:36 PM To: Access Developers discussion and problemsolving Subject: Re: [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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com