Results 1 to 3 of 3
  1. #1
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Isolate non unique records (XP)

    I have a recordset that will be required to act as a bridging table for two seperate databases. I have had to create this by matching two tables, one from each database to create this table. All has gone well until we found that due to dirty data some of the records are not unique!!!

    On the right of the schematic below you will see a sample set of the recordset I have produced, on the left an isolated example. You will not that although the CT values are unique there are different UPRN references.

    I need to isolate these exemption records so that someone can manually check the two databases to see where the problem data arises and change it.

    The right hand column is just me doing a count of the records and will not be part of the final table, but was used as a guide of duplicates I have.

    Can you help me with how I can isolate these records please <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>
    Jerry

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Isolate non unique records (XP)

    Try using the Find Duplicates Query Wizard to find records having the same CT but different UPRN values. You can use the Find Duplicates Query Wizard for a table, but also for a query.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Isolate non unique records (XP)

    Hi Hans

    [slap forehead smiley]...thanks I just needed a new year kick start.....

    I knew it was a two step process from my original, just forgot the second step <img src=/S/bingo.gif border=0 alt=bingo width=15 height=22>
    Jerry

Posting Permissions

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