Avatar of Sandra Smith
Sandra Smith
Flag 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;
Microsoft AccessProgrammingVisual Basic.NET

Avatar of undefined
Last Comment
Sandra Smith

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rey Obrero (Capricorn1)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Sandra Smith

ASKER
I knew there was a way, thanks for reminding me.
Your help has saved me hundreds of hours of internet surfing.
fblack61