By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,394 Members | 1,443 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,394 IT Pros & Developers. It's quick & easy.

Find Unmatched Query Wizard doesn't work

P: 1
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
Oct 18 '07 #1
Share this Question
Share on Google+
2 Replies


nico5038
Expert 2.5K+
P: 3,072
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)
Oct 19 '07 #2

ADezii
Expert 5K+
P: 8,667
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]).
Expand|Select|Wrap|Line Numbers
  1. SELECT *
  2. FROM Test1 LEFT JOIN Test2 ON Test1.PrimaryKey = Test2.PrimaryKey
  3. WHERE Test2.PrimaryKey Is Null;
Oct 20 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.