Acess Duplicate Records

Results 1 to 2 of 2

Thread: Acess Duplicate Records

  1. #1
    Kevin Guest

    Default Acess Duplicate Records

    I have a large Access database that contains two columns with numbers in them. Is there any way to check to see if the number in col1 is also listed somewhere in col2 and if so, delete the number in col2?

  2. #2
    David Moran Guest

    Default RE: Acess Duplicate Records

    Try this:<BR><BR>UPDATE mytable set col2 = null where mytable.key in (<BR>SELECT mytable.key<BR>FROM mytable INNER JOIN mytable AS mytable_1 ON mytable.col1 = mytable_1.col2)

Posting Permissions

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