Totaling the values in multiple rows in a table

[mzungu]

HELP! I’m working for a charity in a small town Tanzania and there is not a soul for miles who knows anything about access.

I have created a database to track requisitions of Office Supplies. I have table full of the requisitions which contains multiple rows for each item we have in the store and the quantity requisition on each occasion.

What I want is a query that will calculate the total quantity of each item requisitioned in a month. Is there an easy way to do this??

 

[FoFa]

First, break out month MTH: Month(MyDateField) into a column all it's own. If you don't use date ranges, you may have to do the same with year as April 2005 and April 2006 are both April (04). Then basically SUM(YourQuantityField) and group by Item and Month.
Basically.