Sum certain items in a continuous form

[Steven]

I have a continuous form that returns for example 12 records. In the footer
section I have a textbox whose ControlSource is Sum([Amount]). I would like
a second textbox that would only sum amounts for records that have a value of
-1 in it's [SelectItemToSum] field. Each record has a Yes/No box whose
control source is [SelectItemToSum] from the table that is visible in the
continuous form. Basically like: Sum([Amount]) Where [SelectItemToSum] = -1.
But how do you do that? The [SelectItemToSum] checkbox on the form is one
that Enabled = True so I can click them on or off.

Thank you for your help.

Steven.

 

[tina]

try

=Sum(IIf([SelectItemToSum] = True, [Amount], 0))

hth