Sorting month by school year

[rpadams]

I have a table (query) that has over 5000 records with two fields, transdate (date), transreason (text). I need to sort them ascending by month (easy to do using format(transdate,"m") but I also need them grouped and sorted in the order July (first) to June(of next year, last). The school year runs July 1 to June 30. Any easy query to do this?

 

[SteveA]

Using format(transdate,"yyyy") will create a field that holds the year of your date which you can then sort on.

HTH
SteveA