Caculating Totals by groups with a number field

[calpolymis]

Hi. I have a tblorder and tbldetail, 1 to many relationship. tblorder has order A, B, C... and each order has detailed items in tbldetail for example CD1, CD2, CD3...
Each item has a number field named Qty for order quantity.

I'm wondering if I can add up the Qty field by items or get a total by a term(monthly, etc..) Something like monthly sales by item, or total monthly sales, etc..

I'm in the logical design phase for a fairly challenging project to me, and this is something I have to know in advance to set up the tables and relationships. Thanks.

 

[PHV]

Anyway, I'd look at the Northwind sample database ...