SUM selected values

[Guest]

Hello

in my form i have this data displayed:

Product Qty Fruit (check box)
Apple 10 yes/true
Sweater 4 no/false
pear 12 yes/true
Peach 8 yes/true
Shoe 10 no/false

i have one field on that form to show all my inventory:
Control Source =SUM([Qty])
i would like another field, also on that form, to show all my fruit inventory.
Control Source =SUM([Qty] IF FruitCheckBox = True) *my literal guess
how do i code this?

Thanks loads!
/amelia

 

[Guest]

Try this
Control Source =SUM(iif([FruitCheckBox] = True,[Qty],0))

 

[Guest]

yeah, that worked.

you rock

thanks!