Sum currency by month Jan, Feb, Mar

  • Thread starter Thread starter Kerman
  • Start date Start date
K

Kerman

I need a query that will sum currency per month. My table has a [batchdate]
field and a [fee] field among others. Ther may be 1,000 records per month.
I need a result showing:

Jan. 2005 $15,025.59
Feb. 2005 $23,124.34
Mar. 2005 $19,234.04

etc. Thanks...Randy
 
I would think a crosstab query would get the results you want.

HTH,
Debbie

|I need a query that will sum currency per month. My table has a [batchdate]
| field and a [fee] field among others. Ther may be 1,000 records per month.
| I need a result showing:
|
| Jan. 2005 $15,025.59
| Feb. 2005 $23,124.34
| Mar. 2005 $19,234.04
|
| etc. Thanks...Randy
 
UNTESTED SQL Statement.

SELECT Format(BatchDate,"mmm yyyy") as MonthYear,
Sum(Fee) As TotalFee
FROM YourTable
GROUP BY Format(BatchDate,"mmm yyyy"),
Year(Batchdate), Month(BatchDate)
ORDER BY Year(BatchDate), Month(BatchDate)

Post back if you can't use this and someone may explain how to do this using the
query grid.
 
Back
Top