Sort by month

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom - 21 Oct 2004 22:55 GMT

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?

Reply to this Message

Marshall Barton - 22 Oct 2004 00:14 GMT

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

Signature

Marsh
MVP [MS Access]

Reply to this Message