Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group/Sort on Formula Field Containing Sums - continued

Status
Not open for further replies.

skystar70

Technical User
Nov 3, 2006
40
US
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
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top