> Also you have not specified what results should be returned where you have > 4 (or more) consecutive dates all with .T. The code above will return the > first-date, first-date + 1, and so on.

tried your suggestion but it doesn't seem to give me the results i need.. like there are records selected that only have 1 tfamt = .T. in a week..

i need to select records with tfamt = .T. in 3 CONSECUTIVE days.. say,

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

12/06/2003 .F.
12/07/2003 .F.
12/08/2003 .T.
12/09/2003 .T.
12/10/2003 .F.

12/11/2003 .F.
12/12/2003 .T.
12/13/2003 .T.
12/14/2003 .T.
12/15/2003 .T.

i should a result of

12/01/2003
12/02/2003
12/03/2003
12/12/2003
12/12/2003
12/14/2003

any more help?