[AccessD] I need a better way to do this - looping

So, you're counting in subsets? 

Susan H. 


>I don't think this will work because I only need to count the number of
> records between the last record and the first record (date descending)
> where the measurement is greater than 100. There may records further
> down in the table that are also above 100 but there are records below
> 100 between these and the first group. For example