AnsweredAssumed Answered

Archive Records

Question asked by RossPartridge on Sep 26, 2012
Latest reply on Jan 26, 2017 by Malcolm


Archive Records


     I have a table with Transaction Records.

     Fields are Member ID; Date; Transaction Type; Amount.

     One of the Transaction Types is "Balance C/F"

     These records are displayed in a portal, listed by Member ID

     I wish to write a script which will:-

     1. Find all records before an entered Date

     2. Calculate a New Balance C/F record as at that new date, from records in found set

     3. Append all records in found set to an identical structured table called "Archived Records"

     4. Delete the found set from original table.

     Anyone have any ideas??