Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2002
    Posts
    3

    Unanswered: Creating a duplicates record file

    I am importing a fixed length text file into Access 2000. The file can grow to over 3,000,000 records. The application is for a telephone service company.

    There are 21 fields of which 3 are needed for this question:

    I need to determine the duplicate phone calls and save them into a table.

    The 3 fields used for this are Date, Phone and Call Start Time.

    The records are being sorted in the above order. It seems easy enough but this is the criteria.

    To be considered a duplicate record, the Dates MUST be equal and the Phones MUST be equal. In addition, the Call Start Times MUST be within 2 minutes of each other.

    Each call is ONLY judged by the call immediately preceeding it. There can be more than one duplicate record. So, for example, you could have the following

    Record1 Start date: 9/25/02, Phone: 4151313457 Start time: 1437
    Record2 Start date: 9/25/02, Phone: 5161234567 Start time: 1500
    Record3 Start date: 9/25/02, Phone: 5161234567 Start time: 1501
    Record4 Start date: 9/25/02, Phone: 5161234567 Start time: 1502
    Record5 Start date: 9/25/02, Phone: 3134567890 Start time: 1532
    Record6 Start date: 9/25/02, Phone: 5161234567 Start time: 1545
    Record7 Start date: 9/25/02, Phone: 5161234567 Start time: 1546

    Even though records 6 and 7 are the same Start Date and Phone, they are in a different group.

    Any ideas on how to create the duplicates table?

    Thanks for any help given.



    Record3 Start date: 9/25/02, Phone: 5161234567 Start time: 1502

  2. #2
    Join Date
    Jul 2002
    Posts
    67
    Aside from the duplicates, will there be 3 million records in your Access db at any qiven time? If so, I recommend you use an enterprise db such as SQL Server or Oracle instead of MS Access.

    Regarding the duplicates: Have you tried using the Find Duplicates query wizard? Just a thought.
    Don't do today, what can be done tomorrow.

  3. #3
    Join Date
    Sep 2002
    Posts
    3
    Originally posted by SLACKER
    Aside from the duplicates, will there be 3 million records in your Access db at any qiven time? If so, I recommend you use an enterprise db such as SQL Server or Oracle instead of MS Access.

    Regarding the duplicates: Have you tried using the Find Duplicates query wizard? Just a thought.

  4. #4
    Join Date
    Sep 2002
    Posts
    3
    Originally posted by SLACKER
    Aside from the duplicates, will there be 3 million records in your Access db at any qiven time? If so, I recommend you use an enterprise db such as SQL Server or Oracle instead of MS Access.

    Regarding the duplicates: Have you tried using the Find Duplicates query wizard? Just a thought.
    Thanks Slacker, this process will happen once per month. The person I am doing this for wants to keep it in Access.

    The db will be deleted once he gets his reports.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •