Calculated Fields in Microsoft Access - How to Perform Calculations in Queries & Form Footer Totals

In this video, I will show you how to use calculated query fields to perform basic calculations on the fields in your table. We will also see how to use form footer totals.

Harold from Las Vegas, Nevada (a Platinum Member) asks: I'm trying to figure out the value of my inventory. I have the cost of each item and the quantity I have on hand. How do I go about calculating the total value of my inventory?

BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an Extended Cut of this video. I will show you how to use calculated table fields (and we'll talk about whether or not you should use them.) We'll also take these calculations over to a report. I'll show you how to use a running sum, and how to create a report page footer total.

MEMBERS ONLY VIDEO:
   • Calculated Fields in Microsoft Access...  

BECOME A MEMBER:
   / @599cd  

LEARN MORE:
https://599cd.com/Calculated

LINKS:
What is a Query: https://599cd.com/Query
Query Design: https://599cd.com/QueryDesign
Continuous Forms: https://599cd.com/Continuous

LEARN MORE:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
Get on my Mailing List: https://599cd.com/YTML
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/Consulting
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...
Email Me: [email protected]

KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, calculated fields, calculated query fields, form footer total, calculated value in page footer report #Error, running sum, report page footer totals, build an expression, create a calculated field in access, calculating field, calculated columns, formulas in queries

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.