Unmatched Query

[Guest]

I created a "Find Unmatched Query"
I am comparing a table to a query – Access is not finding ANY unmatched
records. I know that there are NO duplicates in the table and there are NO
empty fields. What else should I look for? I can’t figure out why the query
is not find these unmatched records.

HELP

 

[John Vinson]

I created a "Find Unmatched Query"
I am comparing a table to a query – Access is not finding ANY unmatched
records. I know that there are NO duplicates in the table and there are NO
empty fields. What else should I look for? I can’t figure out why the query
is not find these unmatched records.

HELP

Please post the SQL view of the query, and an example of the data
you're expecting to find which isn't there.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guest]

SELECT [Training Grid].SOPNumber, [Training Grid].TrainingType, [Training
Grid].EmployeeName, [Training Grid].DocumentationDate
FROM [Training Grid] LEFT JOIN [SOP Training Information] ON [Training
Grid].DocumentationDate=[SOP Training Information].DocumentationDate
WHERE ((([SOP Training Information].DocumentationDate) Is Null));

To answer your question: What data am I expecting to find which isn't there?
I guess I don't know how to answer that question. I'm comparing a table and
a query. They both have the same fields - The table has 1788 records and the
query has 1731 records. If I'm comparing the same data, why would I have
more records in the table and less in the query? Obviously the query is not
recognizing some records in the table. But how do I find out which records
if the "Unmatched Query" is not finding them? Sorry, I'm confused.

Thank you for your time, Natalia