View original (French)

Compare two columns in Access

blanc_dordor Posted messages 47 Registration date   Status Member Last intervention   -  
blanc_dordor Posted messages 47 Registration date   Status Member Last intervention   -
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

  1.
    castours Posted messages 2955 Registration date   Status Member Last intervention   217
     
    Hello
    With Access, we can perform a duplicate search between two tables using a specific query for this task.
    0
  2. blanc_dordor Posted messages 47 Registration date   Status Member Last intervention   1
     
    Hello castours,

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

    Thanks in advance.
    0
    1. castours Posted messages 2955 Registration date   Status Member Last intervention   217
       
      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
      0
    2. blanc_dordor Posted messages 47 Registration date   Status Member Last intervention   1
       
      I had thanked you, beavers.
      0