subtotal in a form

[Meryl]

I have a donors subform that lists the donors giving
history and calculates a total. I would also like to put
a current year subtotal in the form's footer.

How can I do this?

 

[Chris Large]

Hi

Assuming there are fields called DonationDate and
DonationAmt then:-

=Sum(IIf(Year(Now())=Year([DonationDate]),[DonationAmt],0))

as the control source of a text box placed in the subform
footer will give you the current year total

hth

Chris