Can someone shed some light on converting a month name to a month number on the fly? (January = 1)
Henry suggested the reverse conversion on a thread from month number to month name: Month(MakeDate(2012,MonthNo))
If MonthName is read as a true date field then simply doing Num(MonthField) should give you the Month Number. If MonthName is read as a text, you can try this:
Thank you Sunny. That worked!
Retrieving data ...