Automate query execution

M

mal152

Hi, im new to Access so pls bear with me :)

I have imported a csv file into a table in Access. I have th
folllowing query that returns the sum of all payments for a particula
month. At the moment, to calculate the 12 monthly totals i have to ru
the query 12 times with a different value of [month]

SELECT Sum([610_GTIPlan_credits].Field11) AS SumOfField11
FROM 610_GTIPlan_credits
HAVING ((([610_GTIPlan_credits].Field3)=[month]) An
(([610_GTIPlan_credits].Field9) Not In (9200031,9200032)));

There MUST be a quick way to automate this and give me the 12 totals a
once - any suggestions would be welcome?
Thanks
--Ma
 
Top