i have a situation where i have a table whose fields are :
-Date reference: is a number which repredents a date in the Date Table (this way it is easier to manupilate dates)
-value of payment: the monetary value of the payment that has to be paid at that date
-Paid: here i enter yes or no.
Now customers will input deposits of money. i want to find a way where a query will automatically append "yes" to the "Paid?" field whenever the total value of deposits cover each payment.
date value Paid?
for example if the total deposits the customers paid to buy the appartment is 20000 i want the query to append "yes" to the 3rd row since at that row 20000 has been paid. however if 14999 has been the total deposit by the customers then till only the second row where the "Paid?" field "yes". if its possible, i would also would want a way to find how much money is needed to pay the next payment.
i have no problem using a very different way .any help would be appreciated