Sort by month

[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?

 

[Marshall Barton]

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?

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")