Need Help; Customer Opening Balance Pending Dues on new transaction.

[Nadeem148]

Need Help; Customer Opening Balance Pending Dues on new transaction.


File Attached named Database2.accdb*
I want to use this database for record Water Supply Billing data.
I Have a Billing table which record customer billing details.
I need some query or code which calculate customer previous unpaid dues, just like Electricity bills if we not paid then in next bill Arrears are added in new bill. So i need same at is in my file.Database2.accdb
Please help me. Allah bless you.

[moke123]

I'm sure someone who knows these types of transactions better than I will come along with a better answer but I believe from reading prior posts that your data model is off. I would not use lookup fields or calculated fields in your tables.

I would think you need a transaction table that has fields for the customerID, the transaction date, transaction amount ( + or -), transaction description(new charge, payment, discount applied, penalty assessed,etc.) at the very least.

Things such as Amount currently due or Arrears can be calculated in a query or function and do not need to be a calculated field in a table.

here's a link to a water bill data model ... http://www.databaseanswers.org/data_...ills/index.htm

[Nadeem148]

Thanks sir
But i have no meter data and nor required much more records. Just need simple file