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.
