Jean Thank you. However my approach will only return one row for each invalid transaction. Each row will contain the unique references of an invalid transaction. Your approach is better if Alan wants to see all the rows for each invalid transaction. Perhaps he will let us know which approach he prefers :)
Paul -----Original Message----- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jean MAURICE Sent: 30 January 2012 15:22 To: profoxt...@leafe.com Subject: Re: An SQL Select poser. Paul, it seems very clever and a lot more simple than my solution. Best regards The Foxil Le 30/01/2012 15:21, Paul Newton a écrit : > Alan > > How about Selecting Sum(Value) As n1, Sum(Abs(Value)) As n2 Having Abs(n1) # > Abs(n2) > > Paul Newton > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com 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/96d5b71c2b277647a0ecf548f1ebf52706c284f...@ukfawexmb2.infor.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.
