What is the easiest wayto do a daily calculation for a field in a table!! (1 Viewer)

I am having a problem doing a daily calculation for a certain field within table. Here is my scenario: I have a table w/ the folling fields

intSNC curBalIn SumOfcurPayment PBal interest Total
36349 $1,000.00 $166.00 $834 $.34 $992.24

I want to be able to pull the current interest owed and multiply the PBal by .1, then divide by 365 and add the interest to the new interest and then put back the total interest back into the interest field and do this daily. What is the easiest way to do it. I been trying with queries and can't seem make it do what i want it to do. thanks

Please do not make multiple posts.

This is confusing and exceedingly bad manners.

Read the forum FAQ's and use the search facility.

What is the easiest wayto do a daily calculation for a field in a table!!

With a calulator, I supose !! Ha Ha Ha Ha Ahhhhhhhh

I think your best bet is using the queries. So far there isn't anything I couldn't do, with using a queries. You might have to add a couple fields in the query to make it work. Just my thought