Forum Discussion
Darkmjolnir
Mar 12, 2025Copper Contributor
I would like help writing a query to determine when people should follow up on a late shipment
Basically, I have a table that is a log for when issues of different magazines are received. Here are the fields: Title of the magazine Frequency (Monthly, bimonthly, annual, etc) Issue date (...
Tom_van_Stiphout
Mar 13, 2025Iron Contributor
I typically use 2 queries when I need all fields of the matching record.
Q1 gets me the dates for each title that matches your requirements:
Select Title, max(ReceivedDate)
From tblLog
Where ExpectedDate < Date()
Group by Title
Then I create Q2 with tblLog and Q1, joining on both Title and ReceivedDate.
The same can be accomplished with a single subselect query.