Query to summarize data by month

[wpryan]

Hi All,
I am maintaining a financial database, and would like to make a year-end summary. Data in the table is TransactionDate, TransactionCategory,TransactionType (Income or Expense) and TransactionTotal. I'd like to sum the transaction totals by month. Do I have to make 12 separate queries, and then include those 12 in a new query, or is there a more direct way to do it?

[CJ_London]

use a group by query and group on month or year-month if your data is for more than one year

SELECT format(transactiondate,"yyyymm") As TransactionMonth, sum(Transactiontotal) as MonthTotal
FROM myTable
GROUP BY  format(transactiondate,"yyyymm")

or

SELECT month(transactiondate) as TransactionMonth, sum(Transactiontotal) as MonthTotal
FROM myTable
GROUP BY month(transactiondate)