QRY Problem

[mb4673]

Hello everyone,



I've a problem with QRYs.

I created a QRY from my table "tbl_machinery". In my table I've a column "auditor", which is made with a lookup-wizard & a relationship to another table "tbl_auditor".

In the QRY I linked both tables and replaced the tbl_machinery.auditor with tbl_auditor.auditor.

So far so good, it's displayed correctly. But some records are missing, these one where the auditor is empty?

Where is the error?

best regards,
Mike

[Bob Fitz]

I think you need to change the join between the tables which can be done by right clicking the join line.

The following link may be of interest: https://www.techrepublic.com/article...ies-in-access/

[mb4673]

Thanks Bob,

that's exactly what i've searched.