The column heading is a Date expression and I would like the resulting table to sort January, February etc. by using the expression below:
MonthName(Format([dte],"mm"))
Query sorting just by Format alone is OK, but alphabetical sorting happens once I use the MonthName function.
Bummer!
Thanks for your thoughts or tips on this.
wem3rd
MonthName(Format([dte],"mm"))
Query sorting just by Format alone is OK, but alphabetical sorting happens once I use the MonthName function.
Bummer!
Thanks for your thoughts or tips on this.
wem3rd
Last edited: