1 Reply Latest reply on Oct 21, 2015 4:16 PM by DavidJondreau

    Using SubSummary in another database

    ClayK

      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

       

      Any suggestions?

        • 1. Re: Using SubSummary in another database
          DavidJondreau

          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.