Link to home
Start Free TrialLog in
Avatar of Sandra Smith
Sandra SmithFlag for United States of America

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.Program
FROM tblPersonProgramHistory;
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sandra Smith

ASKER

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