Query Total

[Jimmy]

Hi, Everyone

I have already created a query for two table as below

inv amount month
1 100 5/09
5 101 5/09
6 200 4/09
7 300 3/09
8 101 4/09
9 203 5/09

How to show the total for each month in query ?? I am using access 2002. I
am new user for using access, can you tell me which web site has a tutorial
access information (step by step with pictures for learning) ??

Thanks
Jimmy

 

[KARL DEWEY]

Try this --
SELECT [month], Sum([Amount]) AS Total
FROM YourQuery
GROUP BY [month];