Group/Sort on Formula Field Containing Sums - continued

[skystar70]

Did I just mess up the "Group/Sort on Formula Field Containing Sums" thread by posting the SQL Query? I don't see the section to respond to the posting any longer? If so, this is a continuation of the thread. Lbass, did you get the SQL Query that I posted?

Skystar

 

[lbass]

I flagged the post so that the site owner can change the display so that all is readable again. I copied your SQL into wordpad though, and I'm afraid it is too complex for me to work out exactly how to create a SQL expression or a command that builds in the summaries--and one of those two steps is necessary for a group sort. Do you have someone that could create a view(s) that builds in the summaries? Sorry, I don't think I can do it.

-LB

 

[skystar70]

No, I don't really have anyone accessible that can create this view. I will either manipulate the data in the database or dump the data in Excel and sort it there and publish the Excel report. Thanks for your help though. I appreciate your trying.

Skystar