Total only specific records on a continuous form

  • Thread starter Thread starter str8trini
  • Start date Start date
S

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.
 
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.
Click to expand...

Using an Unbound control:

=Sum(IIf([CheckBox] = -1,[FieldToBeSummed],0))
 
Perfect. Thank you so much!!!

fredg said:
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.
Click to expand...

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
.
Click to expand...
 
Back
Top