How to Sum by month?

[vukas]

hello,

I have a table with 3 fields: Product Name, Date Of Sale, Amount.
My task is to add Amounts for every successive month for which at least 1
entry was made. For example:

Data in the table
2002.03.01 - 1$
2002.05.01 - 10$
2002.05.02 - 20$
2003.06.01 - 100$
2003.07.01 - 1000$
2003.07.02 - 2000$
2003.08.........

Query's answer
1$
30$
100$
3000$
......

What criterias I have to supply to the query to get such the answer?

Thank you!