I am generating a report of kiosk uptime, based off of a log table that has "heartbeat" logs as its entries. I basically need to make a report that shows how long the kiosk was "up" and "down" grouped by day. Basically the application that runs on the kiosk logs an entry in this table every 15 minutes. Definition of down would be a gap greater than 15 minutes between entries. My question is can I constuct a SQL query that will return a recordset representing this, or will I have to use some java or perl code to process the recordset. Thanks for the help.