Find non-matching data

[Guest]

How can find which records in one field of a table are not in another field
of a table?

 

[mikesjLFG]

How can find which records in one field of a table are not in another field
of a table?

You can run a "Find Unmatched Query". If under the queries tab click
new at the top it will allow you to select that wizard.

Hope this helps
Mike

 

[Guest]

You can run a "Find Unmatched Query". If under the queries tab click
new at the top it will allow you to select that wizard.

Hope this helps
Mike

1. Create a selection query.

2. combine the fields you want to find empty.

3. right click on the combination line. you'll find these three options:
a) show only the records where both field are equal
b) show all the records in table A and only the coincident ones in B
c) show all the record in table B and only the coicident ones in A

you should choice between b or c options.

4. establish the filter of the field you are lookin empties to is null


This is my first post. I hope this be clear to you.