Quantities per week??

Hi everyone,

I have a table that has 4 columns on it. The first column is the product
#, the 2nd column is the Date, the 3rd column is the Quantity and the
4th column is the measuring unit. Each product # has many entries in any
date in the table. For example Product A on Date 01/01/2008 has the
following quantities 10 in one filed, 13, in another field, 20 in
another filed, etc. I need to calculate the total Quantities for each
product per week. for Example week of 01/01/2008 (week)1 sold total of
43. Can any one help on this. Thanks in advance

*** Sent via Developersdex http://www.developersdex.com ***