When 8850 Form Totaling 2016-2023

In this video what we're going to try to do is to create a grand total for the order in this particular restaurant database and if you remember previously we've managed to do a calculation in a subform here and what we're now going to do is to transfer the grand total of these values here for all of the items onto the main form itself now fortunately access doesn't make this very easy in fact we have to do in two steps the first step is to perform the calculation here in the subform and then transfer that value into on to the the main form here there are way too much about it I'll take you through step by step and hopefully we'll end up with this total on the main form so the first thing we're going to do is to close down the whole application and I'm going to go to our order subform and place it in designed it and this is where we're going to calculate the total of all of those items for an order and the way which we do this is to put a textbox here into the form footer and what I'll do first of all is to give this particular textbox a meaningful name by bringing up its properties and I'm going to call it order total like that close down the properties dialog and in this part here where it says unbound is where our formula is going to be and we're going to do formula very similar to doing the spreadsheet by using a sum function to add up all of the prices multiplied by the quantities so here we go equal sign first of all then the sum function and we open a pair of round...