访问在SQL视图中给出错误但查询正确运行

I have a query in Access which is returning data from two tables. The one table needs to be filtered however as I need to return the most recent entry for a particular date.I have a query in Access which is returning dat