Writing SQL [RESOLVED]

[salvelinus]

I wouldn't use month as a field name since it's also the name of a function in VB.
Anyway, instead of your WHERE clause, try a GROUP BY month.

[Ecniv]

To expand on salvelinus's post...

You want the montha nd a (sum) total of spend, yet in your Sql you only bring back one sum field and filter on a where.
Tru this works, but you'd need sub queries for each month.

As salvelinus posted, use a group by.

SELECT 
   [table1].[month]
   ,Sum(spent) AS Total
FROM 
   table1
GROUP BY
   [table1].[month]

When you use group by you must list all fields that are not aggregate functions (sum, max, min etc).

Try the above then mess around with the sql, see what happens.