Totals Not Saved: Why Storing Calculated Values in Microsoft Access Can Cause Problems

[@Shadow.Dragon]

Richard, great video! I have a db where I store a "totals" field in the main table. Looking forward to the extended cut to see if I did it correctly. 🙂

[@599CD]

Great idea!

[@AzizAhmadMohammadi-z4y]

Hi Richard 👋 Me make my dB 80% but I need Cancel ,Save and not save method in continu Sub form😢 Please upload This Method learning video For Free😊 Please 🙏

[@GreyPaSM]

Although I agree that queries are a good method of getting a line total, I find that storing the totals in the table really optimize the database by leaps. What I usually do is have an Edit Form so when an invoice or order needs to be adjusted the user can use that. Add some vba after some events and presto, Totals are recalculated. Also, the Edit Form can be used to add other stuff to the primary table like: -Last Edited Date -Edited By User -Reason for Edit Great for the audit trails. This is frown upon by developers but screw that, optimization over tradition any day of the week I say.

[@599CD]

599cd.com/QQ