Search results

I was wondering if this couldn't be handled by SQL by any chance? What I have so far is: SELECT s1.[ActiveTime], MIN(t1.[EventTime]) AS EndTime FROM AMHEfault s1 INNER JOIN AMHEfault t1 ON s1.[ActiveTime] <= t1.[EventTime] AND NOT EXISTS(SELECT * FROM AMHEfault t2 WHERE...

Thanks plog. I'll do my research and I'll post my questions here if that's OK.

Sorry I'm at work and rushing a bit. List should be increasing not decreasing so: ActiveTime EventTime area 15/10/2015 04:54 15/10/2015 05:03 Crane 4 15/10/2015 05:30 15/10/2015 05:40 Crane 4 Which means 05:30 fall after 05:03 not before that's why it's...

For same area, if start time of second record fall before finish time of first record it's related.

Table name: AMHEfaults Fields ActiveTime, EventTime, area A. ActiveTime EventTime area 15/10/2015 16:18 15/10/2015 16:30 Crane 5 15/10/2015 16:16 15/10/2015 16:30 Crane 5 15/10/2015 16:07 15/10/2015 16:17 Crane 5 15/10/2015 12:24 15/10/2015 13:11...

Hello, I have ODBC database reporting faults in automated crane system. Fields I'm using: ActiveTime - When fault started EventTime - When fault was resolved Expr1 - DateDiff("n",[Active Time],[EventTime]) - duration of fault Message - fault description area - area where fault occurred I use...