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??