i have table dtr with fields empno, swipedate and ti1 (logical). i want to select all ti1 = .t. for every employee that falls in 3 consecutive days within a week.

say,

0001 12/01/2003 F
0001 12/02/2003 T
0001 12/03/2003 T
0001 12/04/2003 T
0001 12/05/2003 F

0001 12/06/2003 F
0001 12/07/2003 F

0001 12/08/2003 T
0001 12/09/2003 T
0001 12/10/2003 F
0001 12/11/2003 T
0001 12/12/2003 T
.
.
.
0001 12/31/2003 F

i should be able to select empno 0001 and dates 12/02/2003, 12/03/2003 and 12/04/2003. i should be able to do this per employee. table dtr contains a thousand of different empno.

please advise me..

TIA