Looking for query suggestions

[Bonnie]

I have two tables - master and export. I would like to only show the records
in export that are not in master. I want to do something like:

Show records where field1, field2 and field3 aren't the same in export as in
master.

Basically I am matching again three criteria.

I was trying to use the Unmatched wizard but it only uses 1 field.

Thanks,

Bonnie

 

[John W. Vinson]

I have two tables - master and export. I would like to only show the records
in export that are not in master. I want to do something like:

Show records where field1, field2 and field3 aren't the same in export as in
master.

Basically I am matching again three criteria.

I was trying to use the Unmatched wizard but it only uses 1 field.

Thanks,

Bonnie

You can apply the same logic as the unmatched query wizard using a
build-your-own query.

Create a Query joining export to master by all three fields.
Select EACH of the three join lines and change it to a left outer join - "show
all records in Export and matching records in Master".
Put a criterion on any one of the three fields in Master of

IS NULL

I'm assuming that all three fields have values in all three tables - if you're
trying to treat records with NULLS in both tables as a match it gets trickier.

 

[Bonnie]

That's the ticket.

Thanks John, your a great help.

B