Calculate and add due in payment form

[arifmasum]

I am stuck here for last 5 days. Here is my database. I need to calculate and add due amount for each time payment is made but can not understand how i can do that. I have added my payment table in the database. I am using Ms Access 2007. Please help me if you can. Any help will be appreciated.

 

[Trevor G]

You would need to do the calculation in a query from the data held in the table. Access 2007 won't do calculations in tables.

 

[arifmasum]

thanks a lot for your response. I found the answer. First I did calculation by query then run update query to update record in table. thanks again for your reply

 

[YNWA]

Hi, do you have an example of your solution?

Cheers

 

[tchishanu]

You would need to do the calculation in a query from the data held in the table. Access 2007 won't do calculations in tables.

may i have a sample of the resolved database am looking for same datebase

 

[tchishanu]

Hi am looking for a sample database that will post payments for membership, i also want to figure out how to post payments monthly and also calculate arrears/shotfalls of monthly subscriptions. i also want to print a report that will show me the status of membership based on the joining date