Running SumQ between Records - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Running SumQ between Records

Ian Brandt

3 years ago

Been trying to figure out how to create a running total that is dependent on comparing the value to a previous record. Not sure if DSum() is the correct way to go.

	Ian Brandt OP @Reply 3 years ago

	Ian Brandt OP @Reply 3 years ago
Something like tempVar(Run)=if(LayerN)=1,t,if(LayerS=PreviousLayerS, Run+t,t) But how to read Previous ?

	Kevin Robertson @Reply 3 years ago
Check Register Access Expert 29

Ian Brandt OP @Reply

3 years ago

Hi Kevin, Thanks for the direction. Unfortunately, I am not able to solve this problem based on that information supplied. I keep running into the fact that the RunningTotal refers to itself. Trying to do this in a query and I don't have any tools to deal with that. DSum() has to refer to a field that already exists, but here I need the query field to refer to itself, the record value above.

RunningTotal=if(LayerStage=LayerStage(where LayerNumber-1),t+RunningTotal(where LayerNumber-1),t)
In programming there is usually a temp variable that can store some initial value like 0.

No idea how to solve this in access without denormalizing, as I already have a solution that easily runs between fields (not records) in my current crappliy inefficient DB. ;-).

Anyone have a solution?

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View