Need some query help

Hi,

I have 4 columns (Doc, Date, FT, IRD). Trying to create a query that will set the IRD column to 1 else set it to 0. The criteria to set IRD to 1 is for each FT/Doc combo, find the oldest date within that group and that should be set to 1.

Thanks

aka.
FT Doc Date IRD

1      Text1  1/1/05  1
1      Text1  1/2/05  0
2      Text1  1/30/05  1
2      Text3  2/2/05  1