Total only specific records on a continuous form

[str8trini]

I am trying to add a total to the form footer on a continuous form that will
only total the records marked with a check box field. Is there a way to
specify this in the control source on the total field. For example, I have 4
records displayed on my form and 3 are marked. I only want to total the
value for the 3 marked records in my total line.

 

[fredg]

I am trying to add a total to the form footer on a continuous form that will
only total the records marked with a check box field. Is there a way to
specify this in the control source on the total field. For example, I have 4
records displayed on my form and 3 are marked. I only want to total the
value for the 3 marked records in my total line.

Using an Unbound control:

=Sum(IIf([CheckBox] = -1,[FieldToBeSummed],0))

 

[str8trini]

Perfect. Thank you so much!!!

I am trying to add a total to the form footer on a continuous form that will
only total the records marked with a check box field. Is there a way to
specify this in the control source on the total field. For example, I have 4
records displayed on my form and 3 are marked. I only want to total the
value for the 3 marked records in my total line.

Using an Unbound control:

=Sum(IIf([CheckBox] = -1,[FieldToBeSummed],0))

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.