Need Sum of Weeks Between 2 Dates

[Intui_Sol]

Hello,

I am using MS Access 2003 and I need to make a cross table query or
query with totals to sum values between ranges.

For example I collect the following data:

Start Date Start Date Week End Date End Date Week
4/30/2008 18
5/21/2008 21

I would like to create the following output by summing the amount open
during the weeks open before closed and make a graph:

Open
Week 18 Week 19 Week 20 Week 21
1 1 1 1
Closed
Week 18 Week 19 Week 20 Week 21
Null Null Null 1

I would obviously be able to get a count on start and end dates but I
don't know how I get the dates between; specifically Week 19 and Week
20.

Thanks!

 

[Intui_Sol]

Hello,

I am using MS Access 2003 and I need to make a cross table query or
query with totals to sum values between ranges.

For example I collect the following data:

Start Date Start Date Week End Date End Date Week
4/30/2008 18 5/21/2008 21