How do I find duplicates in different Access tables?

R

Rick B

Please explain your question. Use the actual test area. Your question is
too vague to give you a good answer.
 
R

Rick B

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.
 
L

Lona

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?
 
L

Lona

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)
 
V

Van T. Dinh

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top