Monthly and YTD Totals

D

DAngelia

Hello,
I have the following fields in a query.
PayeeNum
PayeeDate
ChkNum1
ChkAmt1
ChkNum2
ChkAmt2
WeeklyTotal: chkAmt1 + chkAmt2
I get a weeklytotal working okay.
I would like to get the weeklytotal and ytdtotal (for each year) and have
them reset to zero at new year.

How? Help!
 
Top