Link to home
Create AccountLog in
Avatar of "Abys" Wallace
"Abys" WallaceFlag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of "Abys" Wallace
"Abys" Wallace
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer