"Abys" Wallace
asked on
MS Access Running Total- DSum function
Hi Experts,
I need assistance with the correct syntax to create a daily running total of "cases" worked by employee.
With the following fields:
Field: Cases Worked Date
Total: Group By
Sort: Ascending
Show: Yes
Field: Employee Name
Total: Group By
Sort:
Show: Yes
Field: NEW Cases
Total: Group By
Sort:
Show: Yes
Field: # of FU Cases
Total: Group By
Sort:
Show: Yes
I was attempting to use the following to get a daily running total of Follow Up cases for each employee name:
Val(DSum("# of FU Cases","QRY_Daily Productivity_NEWOverall"," [Agent ID] ='" & [Agent ID] & "' and [Last Touch Date] <= #" & [Last Touch Date] & "#"))
Field: Follow Ups: Val(DSum("# of FU Cases","QRY_Daily Productivity_NEWOverall",_
"[Agent ID] ='" & [Agent ID] & "' and [Last Touch Date] <= #" &_
[Last Touch Date] & "#"))
Total: Expression
Show: Yes
I keep getting #ERROR
Thank You
I need assistance with the correct syntax to create a daily running total of "cases" worked by employee.
With the following fields:
Field: Cases Worked Date
Total: Group By
Sort: Ascending
Show: Yes
Field: Employee Name
Total: Group By
Sort:
Show: Yes
Field: NEW Cases
Total: Group By
Sort:
Show: Yes
Field: # of FU Cases
Total: Group By
Sort:
Show: Yes
I was attempting to use the following to get a daily running total of Follow Up cases for each employee name:
Val(DSum("# of FU Cases","QRY_Daily Productivity_NEWOverall","
Field: Follow Ups: Val(DSum("# of FU Cases","QRY_Daily Productivity_NEWOverall",_
"[Agent ID] ='" & [Agent ID] & "' and [Last Touch Date] <= #" &_
[Last Touch Date] & "#"))
Total: Expression
Show: Yes
I keep getting #ERROR
Thank You
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.