Running sum in calculated table row

[geocan2006]

Is there any way to enter an expression in a table row (calculated) to act as running sum like debit, credit, balance ( running sum)
Thanks

[Micron]

If there is (and I doubt it) it would be something that no seasoned db developer would do. Calculations should only be done in forms, reports and queries, except in rare cases.

[ssanfu]

You should see About calculated table fields

[June7]

Don't think it's going out on a limb to say this is not at all possible in table. Build a report and use textbox RunningSum property. The trick is calculating a starting balance for a period. Very common topic.

[geocan2006]

I consider myself more than average excel programmer however when I discover the dynamic of access I just cant stop wanting to convert my excel file with 20+ sheets and hyperlink to create reports, I have this mistrust since 20 years, whenever I enter a data I always want to see if well sums in report sheet I have created. Excel sucks when you push it's limits. I have to find a way around however I am not the only person in the planet wanting this solved. a bit disappointing by the Microsoft Access programmers set the rule limiting the capability
Thanks

[orange]

Interesting.

I am not the only person in the planet wanting this solved. a bit disappointing by the Microsoft Access programmers set the rule limiting the capability

If you want a database, use database software. If you want a concoction of spreadsheets to attempt to make a database, use spreadsheet software. You'll find, if you research the people wanting to convert multisheet Excel applications to database, they are challenged to deal with relational database concepts.

Access and Excel are different products serving different environments and are built on different object models. The restrictions, that you find limiting, reflect the underlying concepts on which these different tools were designed and built. And each has a broad following.

[Micron]

Agree with Orange. It seems that your disappointment is based on not understanding that they are 2 entirely different tools that may look the same on some level but are not the same. Understanding how to get what you need in and out of a db and being confident on the accuracy of that comes with knowledge and practice. Once you understand the reasons for not storing calculations at the table level you will probably be less disappointed by it.

[June7]

I think other database platforms such as SQLServer, MySQL, Oracle handle running sum calculation in query easier than Access. It can be done in Access, just not simply.

Access has RunningSum property of textbox on report.

Access also has DSum domain aggregate function which can be used on form or in query that can provide a running sum calculation.