Multiple field record match (1 Viewer)

[ckluck]

Is it possible to set up a query that matches multiple fields between tables? In other words...I have table 1 with key fields 1-5 and table 2 with matching records and key fields 1-5. Can I run a query where it matches the key fields in table 1 with the key fields in table 2 and shows any reords where all five fields do not match? I can tie the two tables using a cust number but it is not a primary key as there are multiple records for each customer.

 

[Pat Hartman]

Create a new query.
Add both tables.
Draw join lines connecting the 5 pairs of fields.
Change each join so that it is a left join rather than an inner join.
Select all the columns you want from the first table.
Add criteria for the pk field of table 2 to select Null values.

This query will select all rows from tbl1 where there is no match in tbl2.

 

[ckluck]

Thanks

Excellent- thanks for the help