Hi,
Anybody have "Ms Access file Invoice having customer previous balance field".
Kindly help me.
Hi,
Anybody have "Ms Access file Invoice having customer previous balance field".
Kindly help me.
Last edited by Nadeem148; 06-28-2019 at 12:18 PM. Reason: Grammar mistake
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
You haven't really said how you want to see it. Another thought is a DSum():
http://theaccessweb.com/general/gen0018.htm
Thanks sir. But i need a sample file if anybody have plz. Ms access
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
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.
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.