Running balance on table

[Mike Hughes]

I have a table which is populated from people entering data on a form.
I have attached a sample of the table.
What I want to know is there a way to add another field to the table, like balance and whenever someone enters a payment or deposit the balance field will show the running balance based on the data in that line.

I don't know if this clear, but best I can do.

Any help would be great!

Thanks Mike

 

[bob fitz]

Hi

Calculations should not (normally) be stored in fields. They should be done as and when they are required. You would normally do this with a query that has the calculation in a field and then base a form or report on this query.

 

[Mike Hughes]

I was thinking that. So I'll take your advice. Thanks. Mike

 

[bob fitz]

Hi Mike

You may find these links of use:

http://support.microsoft.com/kb/290136

http://allenbrowne.com/casu-14.html

 

[Mike Hughes]

Looks like book links. I'll check them out tomorrow. Thanks again for the ideas! Mike