Format Expression sort problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Hi,


Add ORDER BY [DAte Opened]



Hoping it may help,
Vanderghast, Access MVP


Nilesh Butala said:
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
Click to expand...
Opened])*12+Month(Query8![Date Opened])-1);
 
Back
Top