SELECT A.FILE_NO, DATE() - 1 AS Yesterday, A.BA_INT_RATE, MAX((SystemDate].[SystemDate]) AS systemDate
FROM Claim AS A
WHERE A.STATUS_CODE = "OPN";
Above is a query in Microsoft Acces 1997 in the part "MAX((SystemDate].[SystemDate]) AS systemDate" I'm wanting to display the most recent systemdate in the systemdate table into a field called systemdate in my query.
The systemdate table simplay has an index in column 1 and the systemdate in column 2. I can't join the table to the table claim in my query. Is there a way to simply display the most recent systemdate in a field called systemdate in my query?
If not is there any suggestions on how I could accomplish this?
Thank you