Reporting when records are NOT created?

[zoomiest]

I am using MS Access as the query and reporting tool (front end) of an online applicant tracking system. With our custom system, if people forget to click "upload" after selecting their resume file, then the system only saves their field data (contact info), and the attachments table has no resume attachment record created.

Guess what - many people forget to click "upload" after selecting their resume file.

So, how do I query my database, so that I bring up the records with no attachment, when there is no record created?

Here is the SQL view of an existing query that is close - but it only will consider those records WITH an attachment record:

SELECT candidate.date_created, candidate.first_name, candidate.last_name, attachment.original_filename, attachment.text, attachment.content_type, candidate.state, candidate.country
FROM candidate RIGHT JOIN attachment ON candidate.candidate_id = attachment.data_item_id
ORDER BY candidate.date_created DESC;

Any help would be immensely helpful...

[June7]

Attachment field is a type of multi-value field. https://support.office.com/en-us/art...E9BEBBEC31#bm7

Bing: Access query attachment field null

Review http://www.mrexcel.com/forum/microso...tachments.html