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?

Thx.

 

[Marshall Barton]

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.

You can use the aggregate functions in the report header or
footer to display totals of the records in the form's record
source.

The overall total would be:
=Sum(amount)

and a conditional total would be along these lines:
=Sum(IIf(Year(donationdate) = Year(Date(), amount, 0))