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

Link to home
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


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