Counting in Query

[EdwinLawrence]

Hello, I have 2 tables. The 1st has dates in sequential order. The 2nd has a list of items (many) with a start date and "# of days" until an end date. I want to create a query, that for each date in the 1st table, it counts, or sums, how many events are open between the start date and (start date + "# of days" until end date). Ideas? Thanks!

[June7]

What do you want to do with this 'count'.

The easy way to dynamically number records is to build a report and have a textbox with RunningSum property set to Yes, ControlSource: =1

[EdwinLawrence]

I want ot count for any given day how many events are "active". I then need to chart that result. So event A is from Jan 1 to Feb 1 and event B is from Jan 15 to Feb 15, so on so forth. So from Jan 1 to Jan 14 there is one event and from Jan 15 to Jan 31 there are 2 events ...

[June7]

Need to work with data if you want to provide the project.