Not equal?

[sasolini]

Hey,

Can someone pls tell me how can get not equal resoults from my two tables? I have table1 and table2 both with field "Layer" and what I want is to get only that data from table1 that does not have the same Layer as table2.Layer?

I try to JOIN table1 and table2 and i get the same resoult as with this code:
WHERE ((tblACAD_MRK.Layer)=[tblLayerji].[NeteniLayer])

but thats exactly the oposite from what i want, so i try with this code:
WHERE ((Not (tblACAD_MRK.Layer)=[tblLayerji].[NeteniLayer]))

and the code does not give me the resoult that i want, becouse i get all the layers for some reason

So can someone pls tell me what can i do?

THX

 

[Bat17]

Have you tried the "Find Unmatched Query Wizard"?

Peter

 

[sasolini]

hehe, i never use that buttun before

THX