Sort by month

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

Guest

I created a query to extract a date by "mmmm, yyyy". It works well, but I
need to sort it cronologically. When I try, it sorts alphabetically. I can
change the formula to "yyyy, mm" and it with sort correctly, but I would like
to display the month (spelled out) and year. Is there a way to do this?
 
Tom said:
I created a query to extract a date by "mmmm, yyyy". It works well, but I
need to sort it cronologically. When I try, it sorts alphabetically. I can
change the formula to "yyyy, mm" and it with sort correctly, but I would like
to display the month (spelled out) and year. Is there a way to do this?
Click to expand...


Leave the date field alone in the query, all this can be
done more easily in the report.

To sort the report, use Sorting and Grouping (View menu) an
specify the expression:
=Format(datefield, "yyyymm")

In the text box where you want to display the month, use the
expression:
=Format(datefield, "mmmm, yyyy")
 
Back
Top