Troubleshooting unmatched query

[accessmatt]

I've used the Find Unmatched Query Wizard to find data which exists in one but not another table. This has worked for me in the recent past but on the one I ran today, the results are simply showing up as blanks (seeming to indicate that all is matched). However this is not the case as I've purposely unmatched the joined table in order to test. I looked over all of the field types and they match as well. Plus Access isn't throwing any errors. Does anyone have any suggestions for further q/a on this?

[ranman256]

Do the joins have arrows on them? if the join line has no arrow , then it is INNER join and will only show matched.

Are there any NULL filters in the criteria? If its is unmatched (outer join) qry and 1 criteria is set to: IS NULL , then it will only bring all unmatched. blanks.

[accessmatt]

Ranman, they're joined with the arrows going into the table which has fields defined as Is Null. I checked both tables and added Is Not Null in all the fields. Still not working as expected. Any more thoughts before I upload this one for review?