Query help - time between entries

[Scolls]

Hi,

My Access skills need serious improvement as I seem to find myself out of my depth.

I am trying do do some analysis aganst "events" in our system, each is date stamped when it occurs.
I need to know how much time occured between certain even types. E.g. the table below shows an event "NOC Investigtion requested", then some time later "Returned from NOC".
I need to have a query or formula or something that adds up all the time the event spent bewteen these two types.

As you can see it goes through this more than once in its cycle. Ideally these would be seperated but a total/aveage time would suffice.

Any help is appreciated.

event_id Date_Created Event_Name
6301529 10/07/2009 17:22 Fault Report Created
6400545 15/07/2009 15:04 NOC Investigation Requested
6400080 15/07/2009 14:53 User Grabbed Fault
6553238 21/07/2009 23:38 Returned from NOC
6554782 22/07/2009 08:39 User Grabbed Fault
6554831 22/07/2009 08:42 Fault Report Snoozed
6570433 22/07/2009 15:26 Fault Report Snoozed
6570290 22/07/2009 15:23 User Grabbed Fault
6597361 23/07/2009 15:24 Returned from Snooze
6597701 23/07/2009 15:32 User Grabbed Fault
6597774 23/07/2009 15:34 Fault Closed
6697421 28/07/2009 14:04 Fault ReOpened
6699146 28/07/2009 14:44 User Grabbed Fault
6699301 28/07/2009 14:48 NOC Investigation Requested
6706348 28/07/2009 17:47 User Note Added
6775272 31/07/2009 14:43 User Note Added
6778894 31/07/2009 16:23 Returned from NOC
6873890 05/08/2009 14:57 Fault Closed


Thanks
Scolls

 

[DCrake]

Do Not double Post

You seem to have an event Id but you do not have an incident id. This would be required to isolate one incident from another. As some may be repeated and some not. As you are only interested in two headings then filter on these to identify the start stop events.

David