<div>
I knew there was a way, thanks for reminding me.
</div>


<div>
<div class="content wysiwyg-content">
I have a combox box with a list of items. &nbsp;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?<br />
<br />
SELECT &quot;ALL&quot; As Program From tblPersonProgramHistory <br />
UNION<br />
SELECT DISTINCT tblPersonProgramHistory.Pr<wbr />ogram<br />
FROM tblPersonProgramHistory;
</div>
</div>


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;

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

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.

Programming

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,