Query to find different between 2 tables.

[november]

I have a 2 tables. I need to find out the items that exist in 1 and not the other.

I'll be using the Where function.

I'm unsure how to apply this though.

Help if you can please.

 

[MSAccessRookie]

I have a 2 tables. I need to find out the items that exist in 1 and not the other.

I'll be using the Where function.

I'm unsure how to apply this though.

Help if you can please.

Try creating a query using the Unmatched Query Wizard. It is the best approach for Most situations like yours. If that does not work, this Simple Union might be what you are looking for:

Select "Missing From Table 2", {Columns you want to see - Same as in Union Part 2}
From Table1 Left Join Table2
    On Table1.JoiningKey=Table2.JoiningKey
Where Table2.JoiningKey Is Null
Union
Select "Missing From Table 1", {Columns you want to see - Same as in Union Part 1}
From Table2 Left Join Table1
    On Table2.JoiningKey=Table1.JoiningKey
Where Table1.JoiningKey Is Null

 

[pbaldy]

Have you tried the unmatched query wizard?

 

[november]

I feel special.

I completely overlooked the wizards.

I have the difference and feel bad for wasting your time.

 

[MSAccessRookie]

I feel special.

I completely overlooked the wizards.

I have the difference and feel bad for wasting your time.

I never consider it a waste of my time if you have learned something, and I am sure that others feel the same way. Good luck and come back again if you need us.