Calculate the data of Subforms under Datasheet View of the main form.

Hi,

I am learning Access on 599cd while designing a simple inventory management database for my company. I was wondering if there are any methods that I could, under the Datasheet View of the main form, to calculate the total or minimum value of the items in the subforms. Now I am able to calculate the total price or quantity of the items in the subform under Form View of the main form. But, through this method, I could only update the total price or quantity of the item in the main form individually. What I need is that I could update all the main form's items' prices and quantities at a time through update the quantity and the prices of the items in the subform. (The subform and the main form are related by many-to-many relationships.)

I am using Access 365. Any response will be greatly appreciated.

---

Reply from Alex Hedley:

Update Queries are covered in X14