Format Expression sort problem

[Guest]

H
I am using Access 2003. I have query

SELECT (Format(Query8![Date Opened],"mmm yy")) AS Expr1, Sum(Query8.[All Cases]) AS [SumOfAll Cases
FROM Query
GROUP BY (Format(Query8![Date Opened],"mmm yy")), (Year(Query8![Date Opened])*12+Month(Query8![Date Opened])-1)

When I ran this the results came up as

Expr1 SumOfAll Case
Dec 03 2
Feb 04 35
Jan 04 12

What should I do so that my results will show a

Expr1 SumOfAll Case
Dec 03 2
Jan 04 12
Feb 04 35

Appriciate you hel

Niles

 

[Michel Walsh]

Hi,


Add ORDER BY [DAte Opened]



Hoping it may help,
Vanderghast, Access MVP

Hi
I am using Access 2003. I have query

SELECT (Format(Query8![Date Opened],"mmm yy")) AS Expr1, Sum(Query8.[All Cases]) AS [SumOfAll Cases]
FROM Query8
GROUP BY (Format(Query8![Date Opened],"mmm yy")), (Year(Query8![Date

Opened])*12+Month(Query8![Date Opened])-1);