Transfer a summary field total to another page

[The Missing Man]

Hi there,

I have a variety of tables each providing me a summary total for a year's found set of records.

I want to place all of these summary totals from different tables on one page so I can see all of my summaries for an individual year of records. But when I do this on a separate new layout, it doesn't give me my found set summary for the individual year as I would like but instead it give me the grand total for all the fields records combined from the table.

I thought since I cannot link the summary to a different page that maybe I needed to create a global field and have that = the summary field but even that still gives a grand total of all records as opposed to a total for a particular year's records.

 

I would have to think that this is possible but it doesn't seem to want to work. Any help much appreciated.

Thanks in advance,

The Missing Man

[mr_vodka]

Based on what info you have given, seem to me like you can write a script that goes through each of your layouts, grab the summary total into a few global variables, and then display those variables on a "reporting" layout. You could also put them into global fields, but if it only going to be used for reporting, variables would be suffice.

[The Missing Man]

OK, so global seems to be the answer, good to know I was on the right track but why do I keep getting the total in my global for all records as opposed to just my found set?

[mr_vodka]

Are you referencing the right table occurrence? Perhaps at this point you may want to post a sample file.

[The Missing Man]

Thanks for your help