I have a crosstab query which counts when items are due by quarter/year. However, it lists the dates ascending by quarter, regardless of the year. Example: Q1 2001, Q1 2002, Q2 2001, etc. How do I make it sort the due dates properly?

Here's what I have:

Expr1: "Qtr " & Format([Due Date],"q yyyy")

Rearrange the Format():

Expr1: "Qtr " & Format([Due Date],"yyyy q")