Hello:
I'm confused; I have a SQL statement that Access' query builder generates which runs in Access but throws syntax errors when tested using https://sqltest.net/
Here is the code:
SELECT Right$([Divisions]![Unit],2) AS [No], [2ColumnTags]![DivisionName] & [Office] & "<0x0009>" & [MemberName] AS OfficeAndName, [2ColumnTags]![DivisionAddress] & [ADD1] AS Street_1, [9CRRoster].ADD2 AS Street_2, [CITY] & ", " & [STATE] & " " & [ZIPCODE] AS [City-ST-ZIP], [9CRRoster].HOME_NM, [9CRRoster].WORK_NM, [9CRRoster].FAX_NM, [9CRRoster].CELL_NM, [2ColumnTags]![PMTag] AS Expr2
FROM 2ColumnTags, Divisions INNER JOIN 9CRRoster ON Divisions.MemberNumber = [9CRRoster].EMP_ID
WHERE (((Right$([Divisions]![Unit],2))=[2 Digit Division Number]))
ORDER BY Divisions.ID;
?