Steve@trop
Registered User.
- Local time
- Yesterday, 19:48
- Joined
- May 10, 2013
- Messages
- 148
The database I'm working on is used to record machine readings several times a day. Management wants a report to show when there are large gaps in the time between readings (to show if/when they were missed). I'm calling this a "Gap Report". Each record is a set of readings and includes the system time from when the readings were recorded. I'm thinking the query would need to look at all the readings in the order they were recorded and then calculate the time difference between each of them. From there I would need to look at each of these calcuations to see if any are above a certain threshold. Can I do this with a query or will it require a function?