J
JerryS
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.
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.