Need help with runnint totals on a calculated field or some other way to do it.

[Jackson]

I've taken the online Access 13 course and I'm just starting a intermediate Access course. I've also signed up for a VBA course after I finish my intermediate class. I've been trying to write a program on my on and although a real programmer would laugh his butt off at my first single attempt I'm rather proud of what it looks like so far. However, I have one routine that is way over my head. I watched dozens of videos and searched online for and answer and can't figure it out. I've even tried to hire a tutor and so far no one has replied. I see what I'm trying to do in other programs but I'm at a lost as to how they do it. What I'm trying to do is create a sub form with the following: I've tried to use a Dsum query a hundred different ways but cannot get it to update like it should. Not sure if Dsum will work with a calculated field. I'm beginning to wonder if this is possible. But others are doing it...... I've always took pride in figuring out things on my own but this has me beat.

StartingBalance
$100 (This could be a negative balance)



DatePosted AmountDue LatePayment AmountPaid Balance
6/18/2016 $250.00 $25.00 $275.00 $100

I need a running total so that the balance carries down with each record like a checkbook.

I need the same with the following:

AssessmentAmount AmountPaid Balance



Can someone please point me in the right direction? I'm willing to hire a tutor if there is one out there.

Any help will greatly be appreciated.

Jackson 361 673-3999

[RuralGuy]

Here's a couple of links that might be useful:
http://stackoverflow.com/questions/1...ious-row-value
https://support.microsoft.com/en-us/kb/210504

[rpeare]

https://www.accessforums.net/showthread.php?t=61495

Please don't multi post on the same forum.

[Jackson]

Wasn't aware that I did a double pose. Was trying to answer someone that helped me.

[RuralGuy]

I can put the two threads together. It might make it easier to keep track of things. Just say go and it's done.

[Jackson]

Thanks a bunch. I'm a fast learner and I can tell by the answers I'm getting that I'm way over my head. But I really appreciate they replies. Thanks once again.

Jackson

[RuralGuy]

The issue with running totals in Access is that each record stands alone in the data set. One needs to use the tools in Access to specifically locate and retrieve a value from a "previous" record. Reports have built in tools to accumulate a running total but Forms do not. It is the nature of the beast, sorry.