Susan Klos
ksklos at comcast.net
Tue Mar 15 20:59:05 CST 2005
No! I think I could figure that out. How many days in the month had an event? i.e. between 1/3/ and 1/11, there were events on 6 days. Event 1, 2, 3 and 4 occurred between 1/3 and 1/8 and that would be 5 days. Event 5 occurred for 1 day 1/10 - 1/11. That would be 1 day. No events occurred between 1/7 and 1/10. So where there are 8 days when events could have occurred they only occurred on 6 of those 8 days. I thought about somehow placing the events on a calendar and counting only the days which were not null. But, I don't know how to do that. Any thoughts? -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Scott Marcus Sent: Monday, March 14, 2005 7:54 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Strange date question Do you really mean how many events occurred on a given day? Scott Marcus TSS Technologies, Inc. marcus at tsstech.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Klos Sent: Saturday, March 12, 2005 8:23 PM To: AccessD at databaseadvisors.com Subject: [AccessD] Strange date question 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. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com