Find Unmatched Query Wizard doesn't work

[flipperqm]

I have 2 queries with alot of data but when i run the find unmatched query wizard, i tell it which 2 queries but when it asked me to tell it which 2 fields to match, it doesn't show any fields . They are blank matching fields. I read up on the jet service pack and about the macro settings well i have mine on allow all so i don't know what the problem is. Microsoft Access 2007

[nico5038]

I never use the wizard.
Just open the query editor and place the two table(s) and/or query(s).
Now drag and drop the unique key field from the one to the other.
Double-click the new JOIN-line and select option 2 or 3 to make one the "master".
Finally place both keys as fields and enter below the "optional" key the criteria:
Is Null
(Just like that, when there are surrounding quotes remove them!)

Now you'll only get the rows from the "master" table not matching the "slave" table.
By switching the option from 2 to 3 (or vise versa) and moving the "Is Null" you can test the other way around.

Getting the idea ?

Nic;o)

[ADezii]

I have 2 queries with alot of data but when i run the find unmatched query wizard, i tell it which 2 queries but when it asked me to tell it which 2 fields to match, it doesn't show any fields . They are blank matching fields. I read up on the jet service pack and about the macro settings well i have mine on allow all so i don't know what the problem is. Microsoft Access 2007

Here is the SQL of it. The following Query will find all Records in Table Test1 without matching Records in Table Test2 based on the matching PrimaryKey Field in each Table (Test1.[PrimaryKey] {ALL} ==> Test2.[PrimaryKey]).

SELECT *
FROM Test1 LEFT JOIN Test2 ON Test1.PrimaryKey = Test2.PrimaryKey
WHERE Test2.PrimaryKey Is Null;