Hi, im new to Access so pls bear with me 
I have imported a csv file into a table in Access. I have the folllowing query that returns the sum of all payments for a particular month. At the moment, to calculate the 12 monthly totals i have to run 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]) And (([610_GTIPlan_credits].Field9) Not In (9200031,9200032)));
There MUST be a quick way to automate this and give me the 12 totals at once - any suggestions would be welcome?
Thanks
--Mal
I have imported a csv file into a table in Access. I have the folllowing query that returns the sum of all payments for a particular month. At the moment, to calculate the 12 monthly totals i have to run 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]) And (([610_GTIPlan_credits].Field9) Not In (9200031,9200032)));
There MUST be a quick way to automate this and give me the 12 totals at once - any suggestions would be welcome?
Thanks
--Mal