Yes I do have two fields in tables that could be joined and blanks would be
blank. For instance first name and last name would be found in both tables
but these same names would be in different cities. Therefore, I need to
identify the records that match names with cities and then find the one that
do not match in either table. Hope this makes sense. Can someone please
help. Thank you.
I'm sorry, but it doesn't (or maybe I need another cup of coffee).
What are these two tables? What are the relevant fieldnames in the
tables? What (if anything) constitutes the Primary Key? For that
matter, what makes you think that a given city might not have two
people both named (say) Fred Brown? Little Parma, Idaho has three...
You can create a Query by adding your two tables to the query grid.
You can drag any field name from one table to the corresponding
fieldname in the other to find records which match on that field; if
you drag ten fields you'll find records which match on those ten
fields.
And if you put a criterion of
IS NULL
on the Criteria line under a field it will find records where that
field is NULL ("blank").
John W. Vinson[MVP]
