Hi Everybody,

I keep a table that tracks an item with columns of dates when milestones are
met. I want to be able to generate a report each week that totals events that
happened during the previous week. The table I keep looks something like this:

Property Units Type Proposed Contracted Released
ABC 200 New 06/22/08 06/24/08 06/28/08
DEF 150 Used 06/01/08 06/27/08 07/28/08
GHI 300 New 06/25/08 07/25/08 08/01/08

I want a report that shows for the week ending 06/28/08, looks like this:

New Used Proposed Contracted Released
500 150 650 650 200

Suggestions and formulas are greatly appreciated.
--
JerryS