ORA-00936 error when using Access2003

[aruba]

When I execute the query below in Access2003 I receive the above error however it works fine in Access97. Any suggestions for modifying it in Access 2003?
Thanks!
SELECT TEMPUS_PERIOD_ACTUALS.PA_PEREND_DT AS WEEK, Sum([TEMPUS_PERIOD_ACTUALS]![PA_REG_HRS]+[TEMPUS_PERIOD_ACTUALS]![PA_OT_HRS]) AS HOURS, Sum(TEMPUS_PERIOD_ACTUALS.PA_REG_HRS) AS PA_REG_HRS, Sum(TEMPUS_PERIOD_ACTUALS.PA_OT_HRS) AS PA_OT_HRS, TEMPUS_EMPLOYEE.EMP_EMPLOYEE_TYP
FROM TEMPUS_EMPLOYEE INNER JOIN (TEMPUS_ORG_WRKGRP_XREF INNER JOIN TEMPUS_PERIOD_ACTUALS ON TEMPUS_ORG_WRKGRP_XREF.OW_ORG_ID = TEMPUS_PERIOD_ACTUALS.PA_ORG_ID) ON (TEMPUS_PERIOD_ACTUALS.PA_EMP_ID = TEMPUS_EMPLOYEE.EMP_ID) AND (TEMPUS_EMPLOYEE.EMP_ORG_ID = TEMPUS_PERIOD_ACTUALS.PA_ORG_ID)
GROUP BY TEMPUS_PERIOD_ACTUALS.PA_PEREND_DT, TEMPUS_EMPLOYEE.EMP_EMPLOYEE_TYP
HAVING (((TEMPUS_PERIOD_ACTUALS.PA_PEREND_DT)=[Input week end date mm/dd/yyyy]));

 

[r937]

that's an oracle error message, isn't it?

r937.com | rudy.ca

 

[HarleyQuinn]

It is, it's the error for 'Missing Expression'.

Cheers

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[aruba]

How do I tell what the missing expression is?

 

[lespaul]

not sure why you have ! here:

SELECT TEMPUS_PERIOD_ACTUALS.PA_PEREND_DT AS WEEK, Sum([TEMPUS_PERIOD_ACTUALS][b]![/b][PA_REG_HRS]+[TEMPUS_PERIOD_ACTUALS][b]![/b][PA_OT_HRS]) AS HOURS, Sum(TEMPUS_PERIOD_ACTUALS.PA_REG_HRS) AS PA_REG_HRS, Sum(TEMPUS_PERIOD_ACTUALS.PA_OT_HRS) AS PA_OT_HRS, TEMPUS_EMPLOYEE.EMP_EMPLOYEE_TYP
FROM TEMPUS_EMPLOYEE INNER JOIN (TEMPUS_ORG_WRKGRP_XREF INNER JOIN TEMPUS_PERIOD_ACTUALS ON TEMPUS_ORG_WRKGRP_XREF.OW_ORG_ID = TEMPUS_PERIOD_ACTUALS.PA_ORG_ID) ON (TEMPUS_PERIOD_ACTUALS.PA_EMP_ID = TEMPUS_EMPLOYEE.EMP_ID) AND (TEMPUS_EMPLOYEE.EMP_ORG_ID = TEMPUS_PERIOD_ACTUALS.PA_ORG_ID)
GROUP BY TEMPUS_PERIOD_ACTUALS.PA_PEREND_DT, TEMPUS_EMPLOYEE.EMP_EMPLOYEE_TYP
HAVING (((TEMPUS_PERIOD_ACTUALS.PA_PEREND_DT)=[Input week end date mm/dd/yyyy]));

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi