G
Guest
Can someone give a hand with adding a running total to my query, as I had a
bit of difficulty with it? As you can see 'FTE' is a caclulated field. What I
would like to do is have a running total right next to that column. Thank you
SELECT [EMPLOYEE INFO].[Employee Name], [EMPLOYEE INFO].[WK GP], [EMPLOYEE
INFO].[PB START], [SchedHrs]/40 AS FTE
FROM [EMPLOYEE INFO]
WHERE ((([EMPLOYEE INFO].[WK GP])="svtra"))
ORDER BY [EMPLOYEE INFO].[PB START], [EMPLOYEE INFO].[Employee Name];
bit of difficulty with it? As you can see 'FTE' is a caclulated field. What I
would like to do is have a running total right next to that column. Thank you
SELECT [EMPLOYEE INFO].[Employee Name], [EMPLOYEE INFO].[WK GP], [EMPLOYEE
INFO].[PB START], [SchedHrs]/40 AS FTE
FROM [EMPLOYEE INFO]
WHERE ((([EMPLOYEE INFO].[WK GP])="svtra"))
ORDER BY [EMPLOYEE INFO].[PB START], [EMPLOYEE INFO].[Employee Name];