T
Toria
Hello,
I have two tables in the same file: Table 1 and Table 2. They have
different fields but have one in common: BAN. I need a query to pull
duplicate BAN records from the two tables. The Find Duplicates query isn't
working for me (I get no results).
The reason to find the duplicates is to take information from table 2 (rep
name, phone, etc.) and plug that info into the record on table 1 with the
same BAN. If there's a way to automate that as well, that would be wonderful.
Thank you!!
I have two tables in the same file: Table 1 and Table 2. They have
different fields but have one in common: BAN. I need a query to pull
duplicate BAN records from the two tables. The Find Duplicates query isn't
working for me (I get no results).
The reason to find the duplicates is to take information from table 2 (rep
name, phone, etc.) and plug that info into the record on table 1 with the
same BAN. If there's a way to automate that as well, that would be wonderful.
Thank you!!