Sorting Months incl All

B

Barb

Hi Everyone
I have a combo box on a form displaying Months. I have them sorted from Jan
to Dec based on numeric value of the month. I'd like to add option "All", but
then I have to use "*" in my numeric column and it converts to text. And then
my sort is messed up. How do I add option for "All Months" as my first choice
in combo box and then have it followed by months - sorted from Jan to Dec?

Thanks
Barb
 
Top