In this video, what we're going to do is create a grand total for the order in this particular restaurant database. Previously, we managed to calculate the total in a subform. Now, we are going to transfer the grand total of these values onto the main form. Unfortunately, Access doesn't make this process easy, requiring us to do it in two steps. The first step is to do the calculation in the subform. We will close down the whole application and go to the order subform in design view. Here, we will calculate the total of all the items for an order. We will put a text in the form footer, which we will name "order total". In the unbound section, we will use a formula similar to a spreadsheet. We will use the sum function to add up all the prices multiplied by the quantities. The formula looks like "=SUM([price]*[quantity])". Now, we can view the total by going back to the form view for the subform. However, if you don't need to see it, you can skip this part. Once we verify that the total is correct, we go back to the datasheet view and save the changes. Next, we need to transfer the order total value to the main form. We go to the main form in design view and add a text . We make it long enough to accommodate the formula. The formula is quite long and complicated, so follow along carefully. We start with an equal sign and in square brackets, we place the name of the subform, which is "[orders subform]". Then, we add ".Form" followed by an exclamation mark. After that, we add the name of the new field in the subform footer, which is "order total". Lastly, we adjust the formatting of the text to...
Award-winning PDF software
Video instructions and help with filling out and completing When 8850 Form Totaling
