Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Monthly and YTD Totals

Discussion in 'Information Technology' started by DAngelia, Oct 30, 2005.

  1. DAngelia

    DAngelia
    Expand Collapse
    Guest

    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!
    --
    Thanks
    D''''Angelia
     
  2. Loading...


Share This Page