For years I’ve used the concept of sub-summary by dealer when sorted by dealer when all sales for year have been found for all dealers. This has always been great.
Now I want to move information found in sub-summary into other files so that I can follow each dealer sales for period of three years. I don’t see how I can export sub-summary information by itself. I have manually transferred files by retyping so that I could rank everyone by automatically numbering files from1 to ……., but copying the sub-summaries by hand is not the way
1) Why use separate files for separate years? It's generally best if you keep all years together. There are other ways to sort by year.
2) Within that same file, you could create an additional table that would hold the summary data. To fill that table, use a script to capture the summary data into a variable and Set Field into that other table's field.