I have a form that has a value in a field and have made many attempts to use that value to select a range from a table on the basis of the value in the form field and then sum the values in the column that met the condition (in form field) and display a running total of the sum in another field on the form.


I've attached a sample file for clarity.

Any assistance wuld be greatly appreciated as it appears to be beyond my skill level.

Thanks.ShipTotTest.xls