You could do that a few ways with VBA, most notably probably is a calculation using criteria on a DCount

You could also do it with a query with criteria between dates on the date field

If you just want the total at the bottom of the form to adjust to certain date ranges that you set, I would use the query option. If you need something more customized you'll have to go with a VBA option.

Thanks Adam. I don't know VBA yet. Still working on expert level 3 course. Query will not help as I wanted a running total of all the amounts paid on that date when I click on any one of those records. Looks like it is beyond me for now. Thanks anyway.

Depending how you run your payments and if your date field has times or not. I'll give you a hint to start messing with

DCOUNT("Payment","PaymentTable","PaymentDate<=" & PaymentDate)

If you do have multiple same day deposits, the "running balance" will clump those days together, so all of them will show the same running balance. You can try to get around that by also using the ID field, depending on your setup/use again.

DCOUNT("Payment","PaymentTable","PaymentDate<=" & PaymentDate & " and ID<=" & ID)

Just some ideas to start playing with.