Running Total on a form

[Guest]

I have a form with items delivered on a certain date, with one field called
"Paid" with the yes/no option (tick box).

What I would like to do is create a texbox on the bottom of the form, with a
running total of only the records that are ticked in the Paid field

 

[tina]

i assume you're totaling a numeric value in another field. if so, add an
unbound textbox control to the form's footer. in the control's ControlSource
property, add the following, as

=Sum(IIf([Paid], [NameOfNumericField], 0)

hth

 

[Guest]

Comes up as #error

i assume you're totaling a numeric value in another field. if so, add an
unbound textbox control to the form's footer. in the control's ControlSource
property, add the following, as

=Sum(IIf([Paid], [NameOfNumericField], 0)

hth

I have a form with items delivered on a certain date, with one field called
"Paid" with the yes/no option (tick box).

What I would like to do is create a texbox on the bottom of the form, with a
running total of only the records that are ticked in the Paid field

 

[tina]

post the expression you entered in the unbound control's RecordSource -
copy/paste it, don't type it in. and tell us the name of the unbound
control. also, what is the name of the numeric control? and is [Paid] the
correct name of the Yes/No field in the form's underlying table?

Comes up as #error

i assume you're totaling a numeric value in another field. if so, add an
unbound textbox control to the form's footer. in the control's ControlSource
property, add the following, as

=Sum(IIf([Paid], [NameOfNumericField], 0)

hth

I have a form with items delivered on a certain date, with one field called
"Paid" with the yes/no option (tick box).

What I would like to do is create a texbox on the bottom of the form,

with
a

running total of only the records that are ticked in the Paid field