Find Duplicates in two tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

1st is Sales Enquiry’s (People who call in)
2nd is Contacts (information gathered via marketing)

Each has a field called Business I need a query to look @ the tables and
tell me
If there are duplicates when business name and postcodes match.

I think I need a union query? Im new to all this so please keep it simple.
Help.

James ( project due in college in 3 hours) no 2hr 58mins
 
What do you mean by "duplicates"? Those entries where the Business Name and
Postcode exist in both Sales Enquiry's and Contacts, or are you looking for
duplicate entries in, say, the Contacts table?

If you want entries that exist in both, join the two tables on business name
and postcode, and the query will only return those rows that exist in both.
 

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

Similar Threads

Find duplicate records in two tables. 2
linking fields from different tables in same database 4
Need to Find Duplicates from Two Different Tables 7
Remove duplicates in Access 2003 database 3
Deleting Duplicate records from two tables 2
Comparing two tables 6
Find Duplicates in 10 tables 10
Finding Duplicates within multiple tables 9

Back
Top