Calculate Line Item & Form Footer Totals

In this video, I will show you how to calculate form footer totals. We will first calculate a total for each record (row) to get a line item total, and then we'll sum up all the line item totals to get a grand total for the entire set of data.

Julian from Alpharetta, Georgia (a Platinum Member) asks: I have a table that contains products, how many of each were sold, and the sale price of each item. How can I total that information up on the bottom of the table? It's easy to do in Excel. How do I do it in Access?

Members

Members will see how to put the total for a subform's line items in the parent form. Then, we'll learn how to actually store the order total in the order table instead of just calculating it based on the sum of the line items. This is handy if you have to run a large query or report.

•  Extended Cut Video - Silver
•  Database Download - Gold

And yes, I posted my comment about needing an AfterDelete event on Microsoft's Access Feedback Portal.

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!

Links

• Continuous Forms: https://599cd.com/Continuous
• Calculated Fields: https://599cd.com/Calculated
• Invoicing: https://599cd.com/Invoicing
• Access v Excel: https://599cd.com/AccessVExcel

Suggested Courses

• Access Expert 3: https://599cd.com/ACX3
• Access Expert 8: https://599cd.com/ACX8

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

microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, How do you calculate total in access form, How do you sum totals in access, Display column totals, How to Create Calculated Fields and Totals Rows, Displaying sum of totals on form, How to add Totals in Microsoft Access, Totals of Calculated Values, how to sum a calculated field in access form, sum function, microsoft access sum column, ms access query sum multiple columns, add the total row to the query