i am using the nested query option and have a nested query that has two sub querys bases in the repeat.

I do show the sum of the values in each sub query when the repeat runs but I would like a grand total of all the records at the bottom of my table.

How do I get the sum of all the repeated sum values?

Hello Carlin,
It's a little hard to reply directly to this question.
Where do you want to sum these - in server connect or on the page? Can you provide a screenshot of how is your action file structured in server connect?

I am currently doing the sum on the page but if I can do it in server connect think that would be better, but I didn't think that was possible. Can you direct me to a resource to guide me in having the sum done at the server prior to sending the query?