Results 1 to 2 of 2
  1. #1
    raychow22 is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    145

    Finding duplicate records with long text exact data

    Hello Forum,



    Anyone has a query/sql code for finding duplicate records showing the same long text matches. Finding duplicates it words matched no matter how long the text is. This goes for exact matches!

    Thanks,

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,974
    Unfortunately you cannot search using long text/memo fields ... nor can you create queries where the table joins involve those fields.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Finding a long list of records
    By curios in forum Access
    Replies: 2
    Last Post: 01-29-2015, 03:03 PM
  2. Text Box Only Finding Records with Exact Text
    By dannybeaver in forum Access
    Replies: 5
    Last Post: 09-11-2014, 07:38 AM
  3. Finding duplicate data from two columns
    By alcorp in forum Access
    Replies: 3
    Last Post: 07-21-2014, 02:44 PM
  4. Replies: 4
    Last Post: 06-18-2013, 07:36 AM
  5. Replies: 4
    Last Post: 10-11-2012, 07:40 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums