I have a union query that is the source of a report. When I group inside the report I always get a "invalid procedure call. I think it has something to do with the RIGHT and LEN that I am using in the second part of the union query. Any guidance would be appreciated. The union query is as follows:
Code:
SELECT IMPACT.[LAST NAME], IMPACT.[FIRST NAME], IMPACT.[WORK DATE], IMPACT.[HOURS REG], IMPACT.[HOURS OT], IMPACT.DEPARTMENT, IMPACT.AGENCY
FROM IMPACT
UNION ALL
SELECT Left([FULL NAME],InStr(1,[FULL NAME],",")-1) AS [LAST NAME], Right([FULL NAME],Len([FULL NAME])-InStr(1,[FULL NAME],",")-1) AS [FIRST NAME], RANDSTAD.[Date Worked], RANDSTAD.[Reg Hours], RANDSTAD.[OT Hours], RANDSTAD.Dept, Left([Agency],8) AS AGENT
FROM RANDSTAD
UNION ALL SELECT STAFFMARK.[LAST NAME], STAFFMARK.[FIRST NAME], STAFFMARK.[WORKED DATE], STAFFMARK.[HOURS REG], STAFFMARK.[HOURS OT], STAFFMARK.DEPARTMENT, STAFFMARK.AGENCY
FROM STAFFMARK;