Overdue Account Query- Access 2010

[lfarring]

Every time we receive a new document, we are required to log in the information into access. Date received, Recieved From,Document title, Subject. After the document is returned from managment we are to insert a log off date into the "Log Off Date" field and mail out signed document.



How could I implement a query to notify the user of only documents that were LEFT BLANK (not logged off) "7 days after Date Received Field"?

[pbaldy]

Seems similar to:

https://www.accessforums.net/queries...elp-35371.html

[lfarring]

SELECT [MAIL LOG].[Date Recieved], [MAIL LOG].[Recieved From], [MAIL LOG].Subject, [MAIL LOG].Disposition, [MAIL LOG].[Logged Off], [MAIL LOG].[Log Off Date]
FROM [MAIL LOG]
Where [Log Off Date] is NULL AND [Date Recieved] >

How would I get this to have it Show now Log Off Dates that are null ONLY if Date Received is greater than 7 days ago?

[pbaldy]

Change the 30 in the other thread to 7. If I understand correctly, you'd also flip the >.