Access 2010 Comboxbox, make sure the work ALL is always first

Sandra Smith
Sandra Smith used Ask the Experts™
on
I have a combox box with a list of items.  However, I need to have the word ALL as the first but since some of the programs are alphabetically before ALL, how do I make sure that ALL is always the first item?

SELECT "ALL" As Program From tblPersonProgramHistory
UNION
SELECT DISTINCT tblPersonProgramHistory.Program
FROM tblPersonProgramHistory;
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Top Expert 2016
Commented:
try this

SELECT "<ALL>" As Program From tblPersonProgramHistory
 UNION
 SELECT DISTINCT tblPersonProgramHistory.Program
 FROM tblPersonProgramHistory;
Sandra SmithRetired

Author

Commented:
I knew there was a way, thanks for reminding me.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial