How do I troubleshoot unmatched queries in Access?

[Guest]

I have an "unmatched query" with three (3) fields from the two tables linked.
the query should bring a record into the results if a particular field (one
of the three linked) "isnull", yet records I know exist in both tables (three
fields appear to be identical in both tables) are showing in the results.
What should I be looking for to find out why these unwanted records are
appearing?

 

[Guest]

In design view did you make sure to put the criteria of Is Null on separate
rows for each field?

 

[John Vinson]

On Mon, 6 Feb 2006 13:57:28 -0800, Rob McGee <Rob

I have an "unmatched query" with three (3) fields from the two tables linked.
the query should bring a record into the results if a particular field (one
of the three linked) "isnull", yet records I know exist in both tables (three
fields appear to be identical in both tables) are showing in the results.
What should I be looking for to find out why these unwanted records are
appearing?

Could you please post the SQL view of the query?

John W. Vinson[MVP]