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;