Date Range query design

As a matter of fact I was just working on it! Thank you for your response!
I am trying several paths concurrently and was just working on your
suggestion. I am not a programmer so I am a little slow and I like to
understand what I am doing instead of just plugging in the code so that slows
me down too, but it helps me learn. Like I said, I am working on your
suggestion and appreciate your time so much. I will get back to you as I
have questions... and I will have questions.

Thanks again,

Karen

KenSheridan wrote:
Have you tried using an auxiliary calendar table in the way I described?
Such tables are commonly used when dealing with data where a period of time
is recorded by start and end dates in a table. The calendar table supplies
the intervening date values to make up the sequence, and it then becomes very
easy to compute aggregated values over all or part of the sequence. As well
as situations like yours calendar tables can be used for appointment systems,
hotel room bookings, leave assignment etc, etc.

As you'll have seen from my first post a query which joins the expenses and
calendar table can easily return the aggregated values for the part of the
full range for an expense which intersects with the queried range.

Ken Sheridan
Stafford, England

Realized that Query based on the query is not going to work becasue the
calculated number of days is not for the correct range. It is for the expense
[quoted text clipped - 16 lines]
help
will be greatly appreciated!

--
Message posted via http://www.accessmonster.com

I just got all the Tables and Code put in place and it works great. I wasn't
sure initially if I had the skill to implement it but it was really easy once
I got into it and it works like a dream! Thank you so much for your time and
I appreciate the way you explained the process.
Thanks again,

Karen

KenSheridan wrote:
Have you tried using an auxiliary calendar table in the way I described?
Such tables are commonly used when dealing with data where a period of time
is recorded by start and end dates in a table. The calendar table supplies
the intervening date values to make up the sequence, and it then becomes very
easy to compute aggregated values over all or part of the sequence. As well
as situations like yours calendar tables can be used for appointment systems,
hotel room bookings, leave assignment etc, etc.

As you'll have seen from my first post a query which joins the expenses and
calendar table can easily return the aggregated values for the part of the
full range for an expense which intersects with the queried range.

Ken Sheridan
Stafford, England

Realized that Query based on the query is not going to work becasue the
calculated number of days is not for the correct range. It is for the expense
[quoted text clipped - 16 lines]
help
will be greatly appreciated!

--
Message posted via http://www.accessmonster.com