How do I find duplicates in different Access tables?

  • Thread starter Thread starter Guest
  • Start date Start date
Please explain your question. Use the actual test area. Your question is
too vague to give you a good answer.
 
make that "actual TEXT area"

--
Rick B



Rick B said:
Please explain your question. Use the actual test area. Your question is
too vague to give you a good answer.
 
In Access, I have 2 different tables containing different listings of
companies. How would I make a query that would find any company names that
are present on both tables?
 
Format of both tables are pretty simple:

Comany Address City State Zip Phone ContactInfo

Van T. Dinh said:
"Body of the post / message"???

Cheers
Van T. Dinh
MVP (Access)
 
Probably you need a Query with an Inner Join between the 2 Tables using the
Company as the link Field.

Check Access Help on Inner Join.
 
Back
Top