Compare two columns in Access

Hello,

I have my Access file with two tables that I call fiche1 and fiche2 each. I want to compare a column from fiche1 to a column from fiche2 to find the duplicated elements, since fiche1 has a column that has similar values to a column in fiche2. I would like to have SQL codes that allow me to see the results, and I hope this is possible.

I would like to find the trick (with SQL codes) that allows me to compare a column from fiche1 to a column from fiche2 to find the duplicated values.

How can I do this, please, and where exactly should I go in Access?

Thank you for your help

Configuration: Windows 7 / Chrome 27.0.1453.110

2 answers

  • Votes
  • Date
  • Descending date
  1. Hello
    With Access, we can perform a duplicate search between two tables using a specific query for this task.
    1. Hello castours,

      For this request you just mentioned, can you give me some ideas about it?

      Thanks in advance.
      1. Hello
        in creation mode under Access, duplicate search query,
        you put your 2 tables, then choose the two to compare.
        be careful of the field order to get the right result
      2. I had thanked you, beavers.