Save daily totals from a summary report into another table to track totals over time

Let's say I have a Summary table that totals all the records in a table where [Status]="Open". These are then grouped in various ways so I have subtotals for the various kinds of records that are open...