hi any one
trying to create a query that looks at 2 tbls
in tb1 i have 1 feild and it list colours and in tb2 the same
what i want is the ability to see only results where 2 feilds are equal ie "red" in tbl 1 and "red" in tbl2
and where they are equal "do not show them"
i guess its like a not like criteria but instead of typing a fixed criteria in the QBE gid i want it to look at another tbl
many thanks in advance for your help