M
Meryl
I have a form that lists the donations history for a donor. I would like to
have 2 subtotals - one to subtotal the donations for the current year and one
to subtotal the donations for the prior year. Do I use Sum Iff? If so, what
is the syntax?
I tried this for the current year subtotal, but it doesn't work:
=Sum(Iif Format([Trans-Check Date], "yyyy")=Format(Now(),"yyyy"), [Amount])
Thanks.
Meryl
have 2 subtotals - one to subtotal the donations for the current year and one
to subtotal the donations for the prior year. Do I use Sum Iff? If so, what
is the syntax?
I tried this for the current year subtotal, but it doesn't work:
=Sum(Iif Format([Trans-Check Date], "yyyy")=Format(Now(),"yyyy"), [Amount])
Thanks.
Meryl