Totals on a form

[Guest]

I have a beg Bal + Production - Shipped as a calculation for ending Bal.
1. How do you add ending Bal to a table
2. On the next record Beg Bal should be ending bal but I do not know how to
do this
3. To have an ending bal per day. How can I do this.

Thanks anyone who can help

 

[Joseph Meehan]

I have a beg Bal + Production - Shipped as a calculation for ending
Bal.
1. How do you add ending Bal to a table
2. On the next record Beg Bal should be ending bal but I do not know
how to do this
3. To have an ending bal per day. How can I do this.

Thanks anyone who can help

I don't know how much you know about Access so let me start off with a
few observation and then you can tell us what helps and what makes no sense
to you.

You should not store these results (or almost any computed value) in a
table. You should re-compute it each time you want to see it.

In a report you would group by day and do the computations using hidden
and viable fields in different parts of the report.