Solved: Dsum Error

[evlai]

I am trying to create a running total query in my access, but getting the #Error when i run the query. Can I know how do I solve this?

DSum("[Rollout Quantity]","[F_Mapping FLP2]",
"[DtIdentifier]>=" & [DtIdentifier2]
& " And [PriIdentifier]>=" & [PriIdentifier2] & "")

:banghead: :banghead: :banghead:

[OBP]

Unfortunately a running total query does not seem to be quite that simple, see the "difference" database that I posted here
http://www.vbaexpress.com/forum/showthread.php?t=26530

It also has a running sum version.

[evlai]

Thank OBP - unfortunately I could not get the answer I want referring to your post...
See my result table in the file, I need the running total based on 2 criterias (chk 1 and chk2).can you pls help?: pray2: : pray2: : pray2:

[OBP]

Chk 1 is not a value, did you mean ch2 and Roll out?

[evlai]

I need the running total to calculate the sum of roll out
(based on chk 1 and chk 2) Not sure If I explained this correctly...Much chk 1 = value/ number?

[OBP]

Do you mean like this?

[evlai]

No.
I have converted chk2 to text instead so that it makes more sense :)

[evlai]

:) I found the solution!! This is solved :hi:


SELECT T1.chk1, T1.chk2, T1.[Rollout Quantity], (SELECT Sum([table1].[Rollout Quantity]) AS Total
FROM [table1]
WHERE [table1].[chk1] = T1.[chk1] and [table1].[chk2] >= T1.[chk2]) AS CumRQ
FROM [table1] AS T1
ORDER BY T1.chk1 DESC , T1.chk2 DESC;

Cheers OBP :beerchug: