Using calculated value from previous register

[eduardo10]

Hi, how do I this simple thing in Excel, in Access
bal1 is like: bal0+deposit-check
bal0 use the previous bal1 amount as you see,
the easier thing in excel, but how do I do this in Access?


thanks!
Sample attached

[NTC]

the cell-to-cell method of excel - and calculation changes that auto cascade thru the document are not directly able to be replicated by Access (or any database) because they are different animals.

One can definitely do some work to approach a near replication of your sample with a form/table and design work. Running sums is implemented different, and recalc of a changed value must be trigger by a stand alone query that resets values in the table.

So while this really doesn't explain how to do it for you, as it is involved. I just wanted to drop you a line since you self describe you as a novice - that indeed this is one aspect that is easy in excel but not in a database. So don't get overly frustrated on this.

If you are really intent on implementing this be sure to have an Access textbook from Amazon or a big bookstore - and you will want to explore vba code triggered in AfterUpdate events, calculated values in queries, and Update queries - as these will be key aspects of your designs.

Sorry not to be more helpful.

[eduardo10]

Sorry for the late, hard working…
As you pointed they´re completely different, my example is exactly like this showing something quite easy to do with a spreadsheet
and the difference with a db.
Currently addressed with the table-form-code approach, thanks
Where only the data is stored and calculated fields are recalculated on the fly,
As data may change.
So want to share it and listen if other options are better, about working with calculated fieds and other registers in the same table.

Thanks again, and let´s see...