Help About Adding Up Sums Using A Checkbox

[MelonFuel]

Hello Guys

Im trying to get access add up the checkboxes that have been ticked but not add the checkbox i want it to add up what has been ticked not the number of checkboxes ticked. All the fields apart from the total are on a subform.

There will be 4 fields involved.

- Checkboxes
- Quantity
- Price Of Product
- Total

What i would like to know is if its possible for the checkbox when ticked to multiply quantity by price and add it to the total and if the quantity change from say 2 to 5 then it will add what has been changed to the total.

Thanks

 

[PeterF]

As a checbox has a value of 0 or -1 the easiest way would be a calculated field with:

abs(nz([Checkboxes],0))*nz([Quantity],0)*nz([Price Of Product],0)

And sum the Calculated field in the footer of the form.

 

[MelonFuel]

Just some quick questions:-

- Will this code go on the subform in a textbox.

- About the [Checkboxes] i don't understand is that a general name for all of them on the subform or ???

- Will this code add only the ones that are selected.

- Will this code add the prices to the total.

Thanks

**EDIT**

forget what i said i didnt read it properly i works just now need to auto update the total thanks alot pal many thanks.

Thanks