I have an access table linked to an outlook email folder that is shutdown and restart events associated with a machine [Skid]. The events are time/date when the machine is shutdown [Alarm Received] and when the machines are started [Alarm Cleared Received]. I need to get a time/date field from query to relate to a time date in another query where the time is in order and I can calculate the difference.
The [Skid] number is shared between the two queries. I cant figure out how to get rid of results like the middle record where it uses the first time received and the last time received. I essentially want a time total of how long the machine is off on each cycle that is shuts down.
The two queries that this one joins were the result of splitting the events from the email folder into Alarm Received events and Alarm Cleared Received events. I am sure this is the wrong way to do this but my I don't have programming skills and am attempting to accomplish it with the query builder.
I think this is telling me how to do it but its a little confusing to me.
Please excuse my communication skills. I am not a data professional but these sorts of problems are a large part of my job.