Sum IIf check box

[Guest]

Hi,

I have a form that has a continuous subform within it that list the cost of
items purchased. There is an eligibility check box that the user can tick if
the item is eligible for a rebate. I would like to sum the [Cost] fields but
only sum those fields where the [Eligibility] has been checked. I’m pretty
sure an IIF formula can do this for me but I’m sure how this works with check
boxes. Can someone please help me?

Thanks
Janine

 

[Guest]

An easy way would be to put a text box in the detail section with the contol
source
IIf([Eligibility] = -1,[Cost],0) and hide it. You can then in the form
footer have a textbox with sum([TextBoxName]) and will sum only the items
with [Eligibility] = -1