On Wed, Jan 4, 2012 at 5:04 AM, Adam Buckland <[email protected]> wrote: > Thanks Peter, > > SET BEHAVIOUR 70 worked as did using all fields except the sum() etc... > ---------------
Putting all the columns outside of the aggregates in the group by segment. Now that will give you the totals per grouping. I have to wonder why you needed them when you are summing to the item and not the cust & pcode, -- Stephen Russell 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYLCMwy3tJSUPov37iPswUAAaSVeAJjjtDZ+bjHAp=23=q...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
