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.

 

[Monti2]

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

Thank you for your kind help.

Regards,

Monti