Sum amount based on input

[jneirinckx]

Good morning,

Having trouble getting my head around this.

I have a form with subform and in the subform footer have a calculation for the total amount. =sum([amount])

What I would like to do is have another calculation which would show how much was spent based on what year was entered in a text box in the footer of the form.
The field on the subform that it would test against is [paymentDate] and is in a medium date format.

Any ideas would be appreciated.

Jerry

 

[puzzled]

just filter the subform based on the entered date, it's much easier

 

[jneirinckx]

Thanks for getting back to me so quick.

So I have an unbound text box in the footer of the subform where I would input a year. ie 2007

Not sure what you mean by filtering the form based on that input.

I also want to maintain the current sum showing me the total of all records.

Could you give me a little more detail.

Thanks
Jerry