I have some problem to sort below field in my query.
RelMthYr: Format([fstrlsedt],"mmm-yyyy")
It turned out to be Apr-2009,Aug-2009,Jul-2009 etc....i'm looking for
Jan-2009,Feb-2009,Mar-2009 etc...
Thanks
If you want to sort chronologically, just sort by fstrlsedt. The Format()
function takes a date (which sorts chronologically) and converts it into a
text string (which sorts alphabetically).
I'd be inclined not to format the field in the query design at all; instead
just set the Format property of the Textbox on the form or report where the
data is being displayed.
Others have suggested using the Month() function to get a numeric month (which
will sort correctly); this is fine, but it will sort January 2010 before
December 2009 (or for that matter before March 1998).