Query with combination of fields in one table and not another

[BrianFawcett]

I am trying to create a query which I am going to use to build a report. What I need to do is create a condition in the query where i want to return the records for one Table (RFQ Sent) where there are not a corresponding combination of two field (Supplier and Part) in a second table (RFQ received). Can anyone help me out?

[weekend00]

try left join query:

select a.* from [rfq sent] as a left join [rfq received] as b on a.supplier=b.supplier and a.part=b.par where b.part is null

[BrianFawcett]

Isn't a Left Join only going to include the records from tbl_RFQSent where the two fields are contained in tbl_RFQReceived?

I want to include the records where the combination of Part and Supplier for each specific record in tblRFQSent is not in tbl_RFQReceived

[weekend00]

you try, then you know.