Adding select total to subform

  • Thread starter Thread starter tomanddani via AccessMonster.com
  • Start date 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
 
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
 
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),)
 
Back
Top