confused about query

[crescent-centre]

I have a database with a table containing drawings recieved. Each drawing can have many actions, first action is sender detail, date, and letter ref. Second action is sender detail, date, letter ref and status (ie acceptable / not acceptable)
I can run a query which looks for all drawings with a status of not acceptable but i then lose info on sender letter ref or I can run a query which gives the senders letter details but for all drawings, not jut those not acceptable. What I want is a query which looks at all docs sent by C1 AND not acceptable.

 

[FoFa]

OK, Not 100% I understand, but on first pass I would say you have what you need.
SELECT yada, yada, yada FROM MyTable
WHERE (status = "Not Acceptable" OR status is null)

if that doesn't work, give a little more detail.