Forum Discussion
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 (...
Thanks for replying. What i ended up doing that worked is i did a simple query for the table and used max from the sigma symbol options and did <Date() in the criteria for the received date field. Which is probably more or less the same thing as what you said, i'm not sure (i'm new to making access databases so i'm not great with the lingo).