Running Total Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an error in a query intended to produce a running total... The fields
are Emp Id, Week Ending Date, Hours, Cumulative

This generates an ODBC Error. What am I missing?

SELECT OFDW_WGS_WKLY_PAY_EMP.EMPLID, OFDW_WGS_WKLY_PAY_EMP.WEEK_ENDING_DATE,
Sum(OFDW_WGS_WKLY_PAY_EMP.HOURS) AS SumOfHOURS, Sum((SELECT SUM(HOURS)
FROM OFDW_WGS_WKLY_PAY_EMP as x
WHERE x.WEEK_ENDING_DATE <=
OFDW_WGS_WKLY_PAY_EMP.WEEK_ENDING_DATE AND
x.EMPLID = OFDW_WGS_WKLY_PAY_EMP.EMPLID))
AS Cumulative
FROM OFDW_WGS_WKLY_PAY_EMP
GROUP BY OFDW_WGS_WKLY_PAY_EMP.EMPLID, OFDW_WGS_WKLY_PAY_EMP.WEEK_ENDING_DATE;



Jim Thomlinson
 
Found it... But now my problem is it is painfully slow... Anything to do that
might speed it up...

SELECT OFDW_WGS_WKLY_PAY_EMP.EMPLID, OFDW_WGS_WKLY_PAY_EMP.WEEK_ENDING_DATE,
Sum(OFDW_WGS_WKLY_PAY_EMP.HOURS) AS SumOfHOURS, (SELECT SUM(HOURS)
FROM OFDW_WGS_WKLY_PAY_EMP as x
WHERE x.WEEK_ENDING_DATE <=
OFDW_WGS_WKLY_PAY_EMP.WEEK_ENDING_DATE AND
x.EMPLID = OFDW_WGS_WKLY_PAY_EMP.EMPLID))
AS Cumulative
FROM OFDW_WGS_WKLY_PAY_EMP
GROUP BY OFDW_WGS_WKLY_PAY_EMP.EMPLID, OFDW_WGS_WKLY_PAY_EMP.WEEK_ENDING_DATE;
 
Back
Top