I am trying to identify the start and stop of a particular incident- these are indicated by the unique values 0,1,2,3,4,5,6.
0 represents no incident- therefore in order to identify when an incident starts and stops and only retrieve these data records (i.e. incident 1) I would like to know how to query or determine when the value in the incident field changes from a 0 to a 1 (i.e. the start) and query when the value changes from a 1 to a 0 i.e. the finish. I only want to compare these changes between adjacent records i.e. those either side of a record.
Any help would be appreciated