Adding select total to subform

  • Thread starter tomanddani via AccessMonster.com
  • Start date
T

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
 
T

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
 
W

Wayne-I-M

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),)
 
Top