Creating a new record in a new table from summary fields?
My main table contains daily sales numbers for multiple locations. One record per day, per location.
I've got the weekly summary worked out, and it works beautifully, however I can see value in having a table that holds those values, as I need to do more things with them.
Is it possible to create a new record in a new table to hold these?
If so, how would I go about it? I think I might be using the wrong search terms.