Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Duplicate Memo Fields

    I have a large database (4000 records). The main data is stored in a memo field. Due to a mistake I made, there are about 50 records in the database where there are pairs of identical records. Other than manually examining all the records, is there an easier way to spots the dups?

    Ronny
    Ronny Richardson

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Duplicate Memo Fields

    4000 records is actually a very modest database, unless you left out a few zeroes. You've run into one of the reasons not to use memo fields to hold your data--you can't index them, which means you can't make them unique.

    You could use a query and the Left$() function to pull the leftmost 255 characters from each record's memo field into a calculated expression, then save that query and use the wizard to create a Find Duplicates query based on it. It wouldn't be perfect, but it might help.
    Charlotte

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Atlanta
    Posts
    568
    Thanks
    7
    Thanked 1 Time in 1 Post

    Re: Duplicate Memo Fields

    Size is, I guess, relative. This is a personal database that no one uses but me so, at least to me anyway, 4,000 is large. To a large company, 4,000 would be tiny.

    Anyway, I started with this solution and I can see that it is going to work. However, I did not install the Find Dup wizard so I have to dig up my CD before I can finish.

    Anyway, like I said, it is going to work. Thanks.

    Ronny
    Ronny Richardson

Posting Permissions

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