Sorting Months incl All

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sort a column by date- by month not year 5
A month selector 1
2 dimensional date sort 1
Months disorder 3
Advanced filter on last months results 6
Sorting Month-Year in Query 7
sort by month out of sequence 4
Sorting dates in the format Jan Feb Mar Apr ... ??? 4

Back
Top