==>Deleting a recordset does note have the current date record

[JOJ via AccessMonster.com]

Pls. see the snapshot of the record set,you can see three recordset for
3 partnumbers.

Date hit Part number Supplier qty

13-10-05 x y 10
14-10-05 x y 10
15-10-05 x y 10
16-10-05 x y 10

13-10-05 x1 y 10
14-10-05 x 1 y 10
15-10-05 x 1 y 10

13-10-05 x2 y 10
14-10-05 x 2 y 10
15-10-05 x 2 y 10
16-10-05 x 2 y 10


On a daily basis one record would be appended to this file by the
system with the current date as the date hit.The group which does note
have the current date record (in the above example 2 nd group x1 partnumber
with 3 records) to be deleted.Could someone tell me the module for the
same.Much appreciate.


Thanks Indeed,
Joe