Hello,
I have the following fields in a query.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6167-monthly-and-ytd-totals.htmlReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6167
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!
--
Thanks
D''''Angelia
*