Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    20

    Unanswered: Duplication prob

    Right then heres my problem

    I have a massive file where i need to find duplications. Now i know you can do a duplication query, but i only want it to take out certain duplications from that file.

    Any ideas ??

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Well here's your problem ... How are you going to uniquely identify the duplicates you want gone???
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Jul 2002
    Posts
    20
    The file is a list of numbers, they are repeated alot, the duplicates i want to take out is the title being repeated

    Example

    Section A534
    89898989
    57857843758
    74748484
    4748498449
    Section A534
    656565656565
    67659797065

    I want to take the second duplicate title out, so it has one heading and then a list of numbers

    Does that make a little more sense now

Posting Permissions

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