Columns are as follows:
Order Date Type Quantity
01/05/2006 Red 100
01/06/2006 Blue 100
01/07/2006 Green 100
01/08/2006 Red 100
01/09/2006 Red 100
01/10/2006 Blue 100

I want to add up how many Red were sold between 1/5 and 1/10. Any ideas?
Thanks
--
JerryS