Hello all,
This question may even not have the standard of being put in the programming category, but still bare me.. I'm very new to access.
The problem with me is as follows. I'm making a database for sale of mineral water in my area. In doing so I have first created a data base of my customers with a "customer enrollment form" and a DB to store the data. Then I created a form to enter the sales details associated with my customers. In that I have the following fields linking to a data base for it -Date of sale, Customer ID, No of bottles & Amount paid. Now suppose one of my customer did not pay me all the amount to the number of bottles he purchased from me, and kept some balance pending. In such a situation I created a Query to calculate the balance amount. Now, the next time when I reach the same customer, I face the same problem, and he again keeps some money pending. In such a situation how can I look at his previous balance and calculate the new outstanding balance..
As I said, I'm very new to all these and so please guide me out of this...
Regards
Kannan