Sandra Smith
asked on
Access 2010 Comboxbox, make sure the work ALL is always first
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.Pr ogram
FROM tblPersonProgramHistory;
SELECT "ALL" As Program From tblPersonProgramHistory
UNION
SELECT DISTINCT tblPersonProgramHistory.Pr
FROM tblPersonProgramHistory;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER