Need to delete duplicate accounts in Access with Date Parameters

[lrea]

I am working in Access 2007 trying to accomplish the following

Here is a data example:
Accnt# Date Time
34866 3/30/09 1:00 pm
34866 1/23/09 3:00 pm
35722 3/24/09 1:00 pm
35722 3/24/09 3:00 pm
376335 1/21/09 1:00 pm
376335 1/6/09 3:00 pm
376335 4/30/09 1:00 pm

I have already pulled all my duplicate Accnt#'s, as you can see the duplicates above. I need to keep the duplicate Accnt#'s that have dates that are more than 31 days apart and delete the duplicates that are less than 31 days apart. In the above example, I want to keep both 34866's because they are more than 31 days apart. I want to delete the minimum of the 35722's (3/24/09 1:00 pm) (i.e. delete the first 35722 since it was done a 1:00 pm). Finally, I want to keep the 1/21/09 3:00 pm 376335 since it is the max of the Accnt# 376335 not 31 days apart and also keep the 4/30/09 376335 since it is more than 31 days from the other two.

The output should be the following:
Accnt# Date Time
34866 3/30/09 1:00 pm
34866 1/23/09 3:00 pm
35722 3/24/09 3:00 pm
376335 1/21/09 1:00 pm
376335 4/30/09 1:00 pm

 

[Remou]

It would be best to post in forum701

http://lessthandot.com