How can I calculate runing sum in access report?

**latifju** · 04-20-2013, 02:04 AM

I have data as given below:

ID	InstDate	InstTaka	AC_Num
1	01-jan-13	3500	38000011
2	01-jan-13	3500	38000028
3	01-jan-13	3500	38000035
4	01-feb-13	3500	38000011
5	01-feb-13	3500	38000028
6	01-mar-13	3500	38000011
7	01-mar-13	3500	38000035

Now I want it [AC_Num]=38000011

InstDate	InstTaka	CumTotal
01-jan-13	3500	3500
01-feb-13	3500	7000
01-mar-13	3500	10500

I am not good in access but I need it so hardly. If you help me to findout the solution I will be bery greatfull to you.

[N.B.

Code:

SELECT Orders.EmployeeID, Sum(Orders.Freight) AS SumOfFreight, DSum("Freight","Orders","[EmployeeID]<=" & [EmployeeID] & "") AS RunTotFROM Orders
GROUP BY Orders.EmployeeID;

I have used this but not work for me.]

Please see the attachment: DSum.zip

Thanks in advance

**amrut** · 04-20-2013, 03:01 AM

The [EmployeeId] field is a date/time field(??). Date/time fields should be always surrounded by "#" sign for calculations.
Try :
SELECT Orders.EmployeeID, Sum(Orders.Freight) AS SumOfFreight, DSum("Freight","Orders","[EmployeeID]<= # " & Format([EmployeeID],"mm\/dd\/yyyy") & "#") AS RunTot
FROM Orders
GROUP BY Orders.EmployeeID;