Need Sum of Weeks Between 2 Dates

I

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!
 
I

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top