Compare two table, based on two fields.

[pip0]

I have two identicle tables, that have two index fields, Type and Code. Both of these fields can have the same value in the respected field but not a unique match where two records in the same table have the same values for both Type and Code.

TableA
Type=A Code=101
Type=A Code=102
Type=A Code=102 - this is not allowed in same table.

TableB
Type=A Code=101
Type=B COde=101


I want to run a report that would pull the records that do not match Type and Code. So if I have the above tables, the report would pull out - Type=A Code=102, only from TableA

Then I would run another report that would tell what in TableB does not exist in TableA based on both Code and Type fields.

Thanks

Michael