G
Guest
I have created a query containing a left statement but get this error. Can
anyone help?
SELECT DISTINCTROW Left([File_Name],Len([File_Name])-4) AS [File Name],
tbl_SAR_Header.Team
FROM tbl_SAR_Header
WHERE (((tbl_SAR_Header.Team)=is_return_variable("SAR_Query_Team_Name")) AND
((tbl_SAR_Header.Return_Date) Is Null))
ORDER BY Left([File_Name],Len([File_Name])-4);
anyone help?
SELECT DISTINCTROW Left([File_Name],Len([File_Name])-4) AS [File Name],
tbl_SAR_Header.Team
FROM tbl_SAR_Header
WHERE (((tbl_SAR_Header.Team)=is_return_variable("SAR_Query_Team_Name")) AND
((tbl_SAR_Header.Return_Date) Is Null))
ORDER BY Left([File_Name],Len([File_Name])-4);