Showing a summary calculation in a form

[prmitchell]

In a subform I have participants who are either left or right (sporting type database)
and as I add participants alternatively left or right
I want to add up the total weight of participants on the left and right
in the form I can add up the total weight of all participants (in the race)
=sum([Weight)]
but I want to break this into total left weight and total right weight

I can do this in a query and then run the query from a button on the form
but is there any way to do this without the user having to click a button

image of form (with subform) attached

 

[JHB]

You can trigger the query to run in the "After update" event for a control or the form.