Counting Consecutive Hours

[Brian K]

Hi, I have a table containing hourly rows for one year.
The hours represent when a certain event occurs so they
are not the total number of hours in the year. I would
like to count the number of consecutive hours each event
occurs. Perhaps a query or report generating the start and
end date/time of each event and the number of consecutive
hours of the event. Does anyone have something like that
or a general direction on how to proceed.
Thanks.
P.S. I don't know if the community are monitor multiple
Access directories so I may post in a couple of other
places. I apologize if you get this more than once.

 

[[MVP] S. Clark]

If you must, Cross post, but don't Multi post.

The task at hand can be easy or difficult, depending on how your table is
structured.

ie.
EventID
EventDate
EventStartTime
EventEndTime

If you have something like the example, then calculating times and summaries
could be quite simple.

Feel free to post your table structure and we'll see what we can do.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-