new to access compare table v table

[andrew29]

Hi,

I have 2 tables.

T1. One existing in a database with a whole lot of data items such as name, date of birth, city, address etc (100000 records).

T2. The other I have impoted and has name and date of birth. (200 records).

What I want to do is see if the records in T2 exist in T1. I'd like to do them all at once so I dont have to specify each name and date of birth 200 times. Records need to match on name and date of birth, to ensure an accurate match.

any help is appreciated.

Thanks

 

[Dugantrain]

The easiest way: Use the Find Unmatched Records Query Wizard. If this doesn't work then
Another way: Write a query which selects all of the fields from T2 and add a new field which concatenates name and DOB in T2 as:

[Name] & [DOB]

Wite a query which will do the same thing for your large table. Now, through this combination of fields, you will have a new field which will uniquely identify each record. Outer join your small table's query to your large table's query and in the criteria of your large table's concatenated field, write

is null

This will then give you a result set of every Name/DOB combination from Table 2 that does not exist in Table 1.