I am getting the below error on my query. I can't see the error in the SQL. Please let me know if you can see why I am getting this error. When I run the query it runs fine.
SELECT Tbl_WO_Log.WO_Bldg_Number, LookupQ_Building_Number.[FPS Building Name], LookupQ_Building_Number.[FPS Building Address], LookupQ_Building_Number.City, LookupQ_Building_Number.State, LookupQ_Building_Number.[Inspector Name], Tbl_WO_Log.WO_Number, Tbl_WO_Log.Alarm_Acct, Tbl_WO_Log.Asset_Number, Tbl_WO_Log.System, Tbl_WO_Log.Problem, Tbl_WO_Log.Leadership_Comments, Tbl_WO_Log.Initial_POC, Tbl_WO_Log.Initial_POC_Ph, Tbl_WO_Log.Log_Date, Tbl_WO_Log.Assigned_To, Tbl_WO_Log.Date_Resolved, Tbl_WO_Log.MIST_ID
FROM Tbl_WO_Log LEFT JOIN LookupQ_Building_Number ON Tbl_WO_Log.WO_Bldg_Number = LookupQ_Building_Number.[Building Number]
WHERE (((Tbl_WO_Log.Log_Date)=Date()) AND ((Tbl_WO_Log.Date_Resolved) Is Null));