group records by area by month versus day

[VIC]

I am trying to write a query that will group records by area by month
versus day. The current result breaks down by each day. How can I
change this query to achieve the desired results?

Here is the SQL query

SELECT [Fraud - Bank Stats Detail].[Edit Date], [Fraud - Bank Stats
Detail].[Check Type], [Fraud - Bank Stats Detail].Area, [Fraud - Bank
Stats Detail].[Curr Reason], [Fraud - Bank Stats Detail].[Check Amt]
FROM [Fraud - Bank Stats Detail]
GROUP BY [Fraud - Bank Stats Detail].[Edit Date], [Fraud - Bank Stats
Detail].[Check Type], [Fraud - Bank Stats Detail].Area, [Fraud - Bank
Stats Detail].[Curr Reason], [Fraud - Bank Stats Detail].[Check Amt]
HAVING ((([Fraud - Bank Stats Detail].[Edit Date]) Between [start date]
And [end date]));

This is the result


Edit Date Check Type Area Curr Reason Check Amt
9/1/2006 1 1 20 18.92
9/1/2006 1 3 20 2856
9/1/2006 1 4 5 140.7
9/1/2006 1 5 5 38.94



Thanks
VIC

 

[Marshall Barton]

I am trying to write a query that will group records by area by month
versus day. The current result breaks down by each day. How can I
change this query to achieve the desired results?

Here is the SQL query

SELECT [Fraud - Bank Stats Detail].[Edit Date], [Fraud - Bank Stats
Detail].[Check Type], [Fraud - Bank Stats Detail].Area, [Fraud - Bank
Stats Detail].[Curr Reason], [Fraud - Bank Stats Detail].[Check Amt]
FROM [Fraud - Bank Stats Detail]
GROUP BY [Fraud - Bank Stats Detail].[Edit Date], [Fraud - Bank Stats
Detail].[Check Type], [Fraud - Bank Stats Detail].Area, [Fraud - Bank
Stats Detail].[Curr Reason], [Fraud - Bank Stats Detail].[Check Amt]
HAVING ((([Fraud - Bank Stats Detail].[Edit Date]) Between [start date]
And [end date]));

This is the result


Edit Date Check Type Area Curr Reason Check Amt
9/1/2006 1 1 20 18.92
9/1/2006 1 3 20 2856
9/1/2006 1 4 5 140.7
9/1/2006 1 5 5 38.94

Since you are not aggregating any values, the GROUP BY
clause is not appropriate. I suggest that you get rid of it
and use an ORDER BY clause instead:

SELECT D.[Edit Date], D].[Check Type], D.Area,
D.[Curr Reason], D.[Check Amt]
FROM [Fraud - Bank Stats Detail] AS D
WHERE D.[Edit Date] Between [start date] And [end date]
ORDER BY D.[Edit Date], D.[Check Type],D.Area