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

Darren:

Here's one example:

SELECT [tblStates].[txtStateCode], [tblStates].[txtStateName] FROM tblStates
UNION Select "<ALL>" As AllChoice FROM tblStates
ORDER BY [tblStates].[txtStateName];

Regards,
Bob Gajewski


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Darren DICK
Sent: Tuesday, April 13, 2004 23:02
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