Unmatched query without wizard

[shevo]

How to I find unmatch records between 2 related tables without using the default unmatched query wizard in access?

 

[Dennisk]

If you don't want to use a query, you will have to use VBA instead.

For each record in the Main table (the One Side)
read the record from the related table (many Side)
if not found then you have an unmatched record

If you are looking for orphaned records then switch the tables around.

 

[neileg]

Why don't you want to use the wizard? It's a bit like riding a bycicle without using the pedals.

 

[shevo]

Why don't you want to use the wizard? It's a bit like riding a bycicle without using the pedals.

Because the administrator in my office never install the wizard option

 

[shevo]

The is no 1-m relationship.
Both table are similar in all fields. They are manually link in the query view by a unique id field.
One list is a current list with old records and the other one is with new records therefore I need to check for unmatched to get the new records that is not in the current list.

 

[neileg]

Sack the administrator!

You can build you own query. Use a left join and check for null records from the right hand table.