Results 1 to 2 of 2

Thread: Find Similar Records

  1. 01-03-2006, 09:15 AM #1
    markporter
    markporter is offline Registered User
    Join Date
    Jan 2006
    Posts
    1

    Find Similar Records

    I'm just beginning to use access - databases aren't really my thing, but I have a question on whether it is possible to do something and if so how...

    I have a reasonably large database of 10,000 records or so each with a number of fields. Amongst these records there have arisen a number of duplicates, but not all are exact duplicates (e.g. I might have one thing which exists twice, assigned to two different companies by mistake). Is there a way of setting up a query to go through this and find all these duplicates? Or is it the sort of thing which can only really be done my hand?
    Reply With Quote Reply With Quote
  2. 01-03-2006, 10:10 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    If there is a pattern in duplicate records then you can write queries, otherwise you have to clean them one by one.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules