Adding select total to subform

[tomanddani via AccessMonster.com]

Hi,
I have a subform and I want to include a total of a control in the form. I
want to total [option cost] if [Include] is checked. How do I do this?
Tom

 

[tina]

add an unbound textbox control to the subform's Footer section, i'll call it
txtTotal. assuming that [Include] is a Yes/No field (checkbox) field, set
the ControlSource property of txtTotal to

=Sum(IIf([Include] = True, [option cost], 0))

hth

 

[Guest]

Create an unbound text box in either the from's header or footer and use this
as the control source

=Sum(IIf(Include]=-1,[OptionCost),)

 

[tomanddani via AccessMonster.com]

Thanks , that worked great!

Tom

 

[tina]

you're welcome