Unmatched combinations

[Monti2]

I need a query that looks at 2 tables and lists those unique combinations of data of the 3 fields in table 1 and table 2. All records in table 2 will also exist in table 1. What I want is those records in table 1 that DONT exist in table 2.

For example:

Table 1-

Make - model - colour
Ford - Mondeo - red
Ford - Mondeo - blue
Ford - Cougar - black
BMW - 318 - red

Table 2-
Make - model - colour
Ford - Mondeo - red
BMW - 318 - red

Required output:

Make - model - colour
Ford - Mondeo - blue
Ford - Cougar - black


I would prefer a graphical quesry solution or SQL solution if possible as I have no knowledge of VBA.

Thank you for reading, and any help would be appreciated.

 

[Mile-O]

Use the query wizard to create a Find Unmatched Query.

 

[Pat Hartman]

The wizard only lets you match on a single field and Monti2 needs to match on three so he'll need to create the query himself.

1. Add tbl1 in the QBE grid, then add tbl2.
2. Draw join lines connecting the three columns.
3. Change the join types to Left.
4. Select whatever fields you want from tbl1.
5. Select the Make field from tbl2.
6. Add criteria to the tbl2.Make column -
Is Null

 

[Monti2]

Pat is indeed correct, and I have it working now.

Thank you for your kind help.

Regards,

Monti