dw134

This question no doubt is so basic it is silly, but I am blowed if I can get this to work.

I am trying to delete records from a table prior to a date 4 days ago. So far all I have been able to succeed in doing is deleting the entire table. Or creating Object errors.

All this merriment is occuring inside Access 2000, using VBA 6.0. Someone please tell me what I am doing wrong, as any more of this and I will have no hair left at all.

braindead

Hi. Have you tried using SQL ?

As in :
Delete * From "TableName" Where "Date Field" < date()-4