Need Ms Access file Invoice having customer previous balance field

[Nadeem148]

Hi,
Anybody have "Ms Access file Invoice having customer previous balance field".


Kindly help me.

[Uncle Gizmo]

Have a look at this "Running Sum" example from Rogers access library it might do the trick.

http://www.rogersaccesslibrary.com/f..._topic279.html

Sent from my Pixel 3a using Tapatalk

[pbaldy]

You haven't really said how you want to see it. Another thought is a DSum():

http://theaccessweb.com/general/gen0018.htm

[Nadeem148]

Thanks sir. But i need a sample file if anybody have plz. Ms access

[orange]

You post lacks details of what you really need. If previous suggestions don't resolve your issue,
you may find this subquery info from Allen Browne helpful.
See
Get the value in another record

[Nadeem148]

SORRY, my mistake
I have this data. and i need "Arrears" Field automatically update on next transaction if customer did not paid. Simply says, the "RemBal" Field of previous month or date for every customer comes to "Arrears" field on every next transaction/date or month of concern customer.

CustomerID_FK	TransDate	Arrears	CurrentBill	Discount	NetDueBill	NetPaid	AfterDue	RemBal
1	30-May-19	0.00	130.00	0.00	130.00	0.00	150.00	150.00
1	30-Jun-19	0.00	130.00	0.00	130.00	130.00	0.00	0.00
2	30-May-19	0.00	130.00	0.00	130.00	0.00	150.00	150.00
2	30-Jun-19	0.00	130.00	0.00	130.00	0.00	150.00	150.00

Kindly Help me.

[orange]

What exactly does that data in that format represent? Is it a report?
Please provide a jpg/png of your tables and relationships showing tables expanded so we can see all fields.
If you can provide a copy of the database with any private data anonymized, that may be most efficient method to get focused responses.
Did you look at the Allen Browne subquery info re getting values from a different record in same table?

Check the Similar Threads area at bottom of this page also.

Good luck with your project.