i have a table with fields date (date type) and tfamt (logical).

i want to select from this table all records with tfamt = .T. that falls in 3 consecutive days in a week..

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.


i should be able to select dates 12/01-12/03...... with 3 consecutive days in a week...

any help?