Sum IIf check box

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIF Query for Numeric Values in Text Field - #ERROR 2
Sum based on Yes/No Field 1
sums on a query 2
Error Msg Box 4
using check box to control text box visibility 4
IIF Statement Help 7
Help with IIf. 1
check box with required fields 3

Back
Top