Form Footer Totals
By Richard Rost 16 months ago
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 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.
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 database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
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
Subscribe to Form Footer Totals
Get notifications when this page is updated
Check out these other pages that may be of interest to you: