Find Duplicates in two tables

J

James123

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
 
D

Douglas J Steele

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