Issues with Storing Calculated Values in Access Tables

In this Microsoft Access tutorial, we'll explore why storing calculated values, like order totals, in your database tables can cause issues. I will show you how to effectively handle calculated fields without saving them, ensuring data accuracy and efficiency across forms, reports, and queries.

Eric from Burbank, California (a Platinum Member) asks: I'm working on reports for my order entry system, and I noticed the order total isn't saved in the OrderT table. How can I save it there so I can use it in my reports and other queries?

Members

In the extended cut, I will show you how to store calculated order totals directly in the order table. We'll discuss how to manage instances where line items are modified, added, or deleted, including creating a custom delete button. This approach is useful for performance optimization and integration with external systems.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Invoicing

Links

• DSum
• Aggregate Query
• Evil Access Stuff

Recommended Courses

• Access Developer Courses

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, calculated fields, storing values in tables, order total calculation, recalculation errors, query-based calculations, aggregate queries, DSum function, extending queries, performance optimization, audit trails, external system integration, asynchronous processing, complex business logic