How do I troubleshoot unmatched queries in Access?

R

Rob McGee

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?
 
K

KARL DEWEY

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

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?
Click to expand...

Could you please post the SQL view of the query?

John W. Vinson[MVP]
 
Top