Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    287

    Unanswered: FInd Duplicate Records

    I need to find duplicate records in my Tables by Surname and Forename and on my Form (Subform which is Datasheet) I want to colour these duplicate records yellow. Or just colour the SURNAME field yellow if possible?

    Can this be done and how please?

    Any help would be appreciated.

    Thanks.

  2. #2
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Create a new query that groups by the Surname and Forename and counts the Surname.

    Add this new query to the query that is the source of the form and link by Surname and Forename. Add the count field to the query.

    Add the count field to the form and use it to change the back color (if me.CountField > 1 then me.SurnameField.backcolor = yellow or use conditional formatting that checks the value of the Count Field).

Posting Permissions

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