Hi there,
I am a rookie in ms access. Somehow I have created a an installment database but now I am stuck in calculating between mainform and subform based on two different tables related in one-to-many relationship. Now I want to show the [TotalPrice] value from mainform in first row of [Previous] in the subform and after subtracting [Amount] from that I want to bring the [Balance] in next row of the [Previous] and than continue with that until balance is zero.