Make a delete query that compares the date.
first pull out the year
InvYear = Year(InvDate)
then for the criteria
<(Year(date())-3)
I think thats right.. Anyone wanna verify that?
I will in a sec. Ill test it.
Sounds like you already have a good idea whats going on.
Without being there we have no way to test your network.
Perhaps you should reboot your servers if you havent done so in a while.