How can the totals from a summary field when sorted by "x" be set into a global field without doing any sort of an export? For example if the values of my summary field are 15, 40 and 100, I need to be able to do a "Set Field" to my global that will place those three numbers into it.

Thanks for any help!!!

Edited April 30, 200718 yr by Guest
removed all caps

Welllll, that is exactly what the set field script step does after all.

Provided you toss in a GetSummary( on righthand side - investigate it's utilization:

http://www.filemaker.com/help/FunctionsRef-341.html

--sd

Thank you for your response. I have used the GetSummary function in the past, however, the problem I have now, is the function only places the first summary total in the global field. How can I have it repeat multiple times until all values are posted in the global field? This data will then be used for charts.

Pretty straight forward:

http://www.kevinfrank.com/download/kf-fast-summary.zip

--sd