On Fri, Jun 20, 2008 at 2:25 PM, Jim Harvey <[EMAIL PROTECTED]> wrote:
> Thanks Stephen, your solution works fine. I had tried that and couldn't get > it to work properly (group by issue). > ------ My trick is to put the computed columns last in the list I ask for. So I can take the entire string of columns in one quick copy and paste in the Group by section. If you ever do an IIF() for say, every period or every quarter this is how you could still "group by." Never say group by 1,2,3,4 always put the text. Other back ends can't deal with it, so if you copy to execute elsewhere you will get burned. HTH -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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/[EMAIL PROTECTED] ** 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.
