Selective sum of field on form. (1 Viewer)

[pekajo]

Hi,
I have a form with two field [IncChk] and [IncTotal].
[IncChk] is a Yes/No field
[IncTotal] is a number.
My question is I want to mark a couple of rows on the form and display the Sum of the selected rows only, in a textbox on the form.

Any ideas?
Thanks
Peter

 

[theDBguy]

Not the most efficient, but one way to do it is to add a yes/no field to the table and then use DSum() on your form.

 

[arnelgp]

can you use Continuous Form?