Hi everyone...

That's my report
Date..............Carriage No
12/06/2006..........2864
09/06/2006..........2862
26/06/2006..........2862
05/06/2006..........2862
08/06/2006..........2860
29/05/2006..........2860
01/06/2006..........2859
02/06/2006..........2857
28/06/2006..........2856
14/06/2006..........2856
13/06/2006..........2855
02/06/2006..........2814

So I would like to find date difference between same carriage numbers.
For Example 2862, how many days between first and second, second and third entry but I'd just skip if there is only one entry as 2859.

Thanks
Cuneyt

query a recordset for a specific record number.
if the rowcount is one, skip. use recordset.getrows with ubound
save date for a record
compare that date to the next record
repeat until finished.