I am trying to build a query (or two) that will return all the values between the first and last records that meet a criteria.
Examples:
ID___Start___End___Height
1____0____5______50
2____5____10_____100
3____10___15_____40
4____15___18_____80
5____18___28_____65
Where all rows between the first time height exceeds 75 to the last time it does. In this instance rows 2, 3, and 4 would be returned. Even though row 3 is below or equal to the threshold of 75, it is included because it's between other rows which are above.
Thank you. I have tried DMin and using First/Last but I keep getting caught up trying to include all the records in between.