I know this should be very easy, but I've not been using Access for months - well at least that's my excuse!
I have a form showing all account transactions with a total deposits box on the footer. I want to change the calculation
to total only those deposits where the account type = 1. Account type being another field in the transaction table.

=Sum(IIf([AccountType]=1,[Deposits],0))

Thank you very much .....