Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    duplicate records (2000)

    I want to find duplicate records based on all fields, whereas the Find Duplicates Query Wizard limits to comparing 10 fields. Is it possible to compare ALL fields? If not, perhaps I could try creating array formulas in Excel to achieve this?? Cheers, Andy.

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: duplicate records (2000)

    Make a Total Query, add all you fields, set the total line for all fields to Group by, add one more field (no matter witch), set the total line for this field to Count and in the criteria line >1
    Francois

  3. #3
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: duplicate records (2000)

    Tops, cheers.

Posting Permissions

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