Challenging Query

[spercoco]

I am a newbie to the forum. I write research reports on publicly-traded companies. In this case, I have two Access databases (i.e. tables) - one for tracking people that also keeps tabs on the companies that they are interested in - e.g. MSFT (the "Contacts" database) and another providing a list of people who have received specific reports that I have written (the "Communications" database). Each record in Communications lists the report number, person receiving the report (and also the date). I want to create a query of all people who are interested in MSFT and also list whether or not they have received my latest MSFT report. (This would allow me to see at a glance those MSFT investors who have not received the report.) Without going into all the details, I am having trouble creating this query. Can anyone help me with this? Also, whether or not you can help, can you provide a reference source (online or perhaps a book or course) that would help me learn how to create complex queries? Thank you for any help that you can provide.

[Gicu]

You may want to read about Left Joins, in your case you want to join the contacts table to the communications table on PersonID with the arrow pointing towards the latest.
https://www.w3schools.com/sql/sql_join_left.asp

https://www.sqlservertutorial.net/sq...ver-left-join/

Cheers,

[ranman256]

then you need a field , maybe a date fld: RptRcvd on the tContacts tbl to put the date they got the report.

join tContact ->tContactStocks and update: RptRcvd = Date()

[isladogs]

Another link that may be useful: Query Join Types (isladogs.co.uk)

[spercoco]

Thanks, Gicu. I was not able to get it to work on a quick retry using your suggestions, but I'll work on it more carefully and let you know how I make out.

[spercoco]

Thanks, ranman. I'll post again when I get it to work.

[Gicu]

It would help to show a screen shot of your attempt.

Cheers,