General :: How To Find Out Total Quantity Sold Per Product

I've now populated my database with all my sales information.

Now, towards plan/prepare 'replenishments' from suppliers, I need to know how many of each product I've sold (ideally between two given dates ....because recent sales history is more important than say sales information from 1 year ago), but let's keep it simple!

How can I get such info out of my database, the info is contained in my database something like this...

Code:
Order date Qty Product ID

1-feb-2014 1 widget A
2-feb-2014 1 widget A
2-feb-2014 1 widget B
3-feb-2014 2 widget A
4-feb-2014 5 widget C

(in my database, qty is declared as 'double', where Product ID is categorized as 'text')

So I'd like an 'order summary' from the above raw data (contained in my database) to look something like this...

Code:
Widget A Sales = 4 units
Widget B Sales = 1 units
widget C Sales = 5 units

How can I do that please? (I looked at access reports, but couldn't see a way of multiplying 'product by quantity' & then total it all up).