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

Answer 1 / 2
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
Answer 2 / 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
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
blanc_dordor Posted messages 47 Registration date   Status Member Last intervention   1
 
I had thanked you, beavers.
0