[AccessD] Strange date question

Susan Klos ksklos at comcast.net
Sat Mar 12 19:22:48 CST 2005


I have a beginning date and an ending date in my events table.  I need to
find out how many days in any given month that one or more events happened.
For example,
Event 1  Beginning Date 1/3/05   Ending date 1/3/05
Event 2  Beginning Date 1/3/05   Ending date 1/4/05
Event 3  Beginning Date 1/3/05   Ending date 1/8/05
Event 4  Beginning Date 1/6/05   Ending date 1/7/05
Event 5  Beginning Date 1/10/05 Ending Date 1/11/05

My query, function, module, whatever works needs to tell me:
between 1/1/05 and 1/11/05 events happened on 6 days.
I can not figure out how to disinclude events if they happened within the
beginning and ending date of other events.




More information about the AccessD mailing list