Hi All,

I'm new to this forum so please bear with me...

I've been trying to work out a way of calculating the number of days that a value has been within a range over many records that are grouped. Here is an example of the main fields:-

ID     VisitDate         Value     RangeLow     RangeHigh    GroupField

 1     01/01/2009        0.9             1                     3               Group1
 2     10/01/2009        1.5             1                     3               Group1
 3     15/01/2009        2.8             1                     3               Group1
 4     20/01/2009        4.0             1                     3               Group1
 5     05/02/2009        2.3             1                     3               Group1
 6     01/01/2009        1.5             1                     3               Group2
 7     10/01/2009        1.5             1                     3               Group2
 8     15/01/2009        3.7             1                     3               Group2
 9     20/01/2009        2.6             1                     3               Group2
10    15/03/2009        2.2             1                     3               Group2


The 'Time in Range' is calculated when 2 consecutive records are in range (in days). I need to be able to summarise the 'Time in Range' for each group as well.

Can anyone help please?????

Thanks

I have tried the Next function but unfortunatley it won't work when you group the records. The records end up in a different order and the calculation becomes inaccurate.