MS SQL v2008, query grouping question

Databases
1

Am extracting three colums from a db - Item, Date, Amount :slight_smile:

Am grouping by Item Year Month :cool: - falling off a barstool time at this stage.

Am trying to use the SUM function on Amount to extract monthly totals :eek: - currently getting Amount per row and not a break amount for month.

What am I missing, besides some television, the love of a good woman, etc etc.

2

Can you post the query, some example table data, the result you’re getting with that data and the result you want?

3

Thanks for the reply but got an answer on another forum.

SUM(Amount) as ‘Month Amount’ worked on monthly totals.