Lesson 33ª







Calculating on Records II

Here, we add the "Orders" Table

Now, the "Clients" and "Product" Tables are related, through the "Orders" Table .

Now, we finish filling the properties of the Query in the grid by adding the field "Totals" in the "In Stock" field and the "Client's First Name" and "Client's Last Name" fields, just like we did in the previous topic.

But this time, we will use the "Sum" option for "In Stock", and we will apply "Group By"the "Client's First Name" and "Client's Last Name" fields

The result of the Query will be: