Moving calculated results from one Table to a separate Table
I have a Table listing 3 group types of students. I keep attendance records of each student in the Table.
I have written scripts to Find, sort & Get(FoundCount) of each group to print the number of studens in each group & to count their attendance to print each week. I count the number of students and the number of class days for each group. I have this working so I print out the attendance and the count results for each week.
I now want to save/store these weekly count results for each group (totals, not per student). I want to save results from each week, so I can later sort them by a weekly date even after the student list has changed. I assume I have to start another Table to add each weeks results as a new Record, but I don't see how to set the counted results from my script to the new Table. Can this be done? Am I missing a simpler solution?