Where to start?

[Oscar]

I have tried to do this using several queries, but can't get it to work and is very messy. I think it would be easier to do this in VB code but don't know where to start.

I have two columns "from depth" and "to depth" in two different tables. These tables are linked by HoleID. I want to find holes where a from AND to depth in table 1 do not match a from AND to depth in table2. It is causing me grief when I do the queries as it gives me all the records for that hole where the from depths do not match, then the to depths, but I ONLY want when both from and to depths do not match. Any help would be much appreciated.

 

[Rich]

Why do you have the same data in two tables?

 

[Oscar]

Because one table stores from - to depths of Mineral Gold occurence and all the data relating to that eg size of gold etc.., the other table stores samples from - to depths with assay results, methods etc... I need the Mineral Gold from - to depth to be the same as a sample interval so we can compare assay results with the occurence of gold. This is the test I can't get to work.