subtotal in a form

  • Thread starter Thread starter Meryl
  • Start date Start date
M

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.
 
Meryl said:
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.
Click to expand...


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))
 
Back
Top