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