×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Need to delete duplicate accounts in Access with Date Parameters

Need to delete duplicate accounts in Access with Date Parameters

Need to delete duplicate accounts in Access with Date Parameters

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close