Forum Discussion
Solved
Dsum
Hello experts, I need to make a running sum total on tblDrawsDetails.Amount but noting the where clause. Please see attached accdb and xls file. I have the following but it just returns the grand...
Hi,
The criteria concatenation in
DSum("Amount","tblDrawsDetails","FacIDfk=" & [FacIDfk] And [ID]<=[ID])) AS RunningSum
should be
DSum("Amount","tblDrawsDetails","FacIDfk=" & [FacIDfk] & " And ID<=" & [ID])) AS RunningSum
Servus
Karl
****************
Access Forever News DevCon
Access-Entwickler-Konferenz AEK
Hi,
The criteria concatenation in
DSum("Amount","tblDrawsDetails","FacIDfk=" & [FacIDfk] And [ID]<=[ID])) AS RunningSum
should be
DSum("Amount","tblDrawsDetails","FacIDfk=" & [FacIDfk] & " And ID<=" & [ID])) AS RunningSum
Servus
Karl
****************
Access Forever News DevCon
Access-Entwickler-Konferenz AEK