sum of selected records in a subform

[najimou]

Hi

I have a filtered continuous subform based on a query with a
calculated field called "charges" and a checkbox "select"
when the checkbox is checked, i need to have a sum for the checked
records in the footer of the subform.

any ideas how i can perform such an action

thanks in advance

 

[Allen Browne]

Firstly, rename your field in your table, and change the Name and
ControlSource of the check box on your form. SELECT is a reserved word, and
likely to cause you problems.

Assuming you have renamed the yes/no field to IsSelected, you can now place
a text box in the Form Footer section of your continuous subform, and set
its Control Source like this:

=Sum(IIf([IsSelected], [Charges], 0)

 

[najimou]

Firstly, rename your field in your table, and change the Name and
ControlSource of the check box on your form. SELECT is a reserved word, and
likely to cause you problems.

Assuming you have renamed the yes/no field to IsSelected, you can now place
a text box in the Form Footer section of your continuous subform, and set
its Control Source like this:

=Sum(IIf([IsSelected], [Charges], 0)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

I have a filtered continuous subform based on a query with a
calculated field called "charges" and a checkbox "select"
when the checkbox is checked, i need to have a sum for the checked
records in the footer of the subform.

any ideas how i can perform such an action

thanks in advance

Worked Perfectly, and thanks very much for your help