Forum Discussion

Darkmjolnir's avatar
Darkmjolnir
Copper Contributor
Mar 12, 2025

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 (...
access
Query
arnel_gp's avatar
arnel_gp
Iron Contributor
Mar 14, 2025

You may also try:

SELECT 
    [Title of Magazine], 
    Frequency,  
    [Issue Date], 
    [Received Date], 
    [Expected Next Issue Date]
FROM YourTable 
WHERE 
[Issue Date] = DMax("[Issue Date]", "YourTable", "[Title of Magazine] = '" & [Title of Magazine] & "'") 
AND 
Date() < [Issue Date] + Switch([Frequency]="Monthly", 30, [Frequency]="Bimonthly", 15, True, 365)

 

Resources