Hi all, I have a choose statement I'm Struggling with. It includes a 5 table join, and a where clause that includes
...and (t5.NetLocalBal+ t5.NetStateBal+ t5.NetNatlBal+ t5.NetM1Bal+ t5.NetM2Bal+ t5.NetM3Bal+ t5.NetM4Bal+ t5.NetInitBal+ T4.LateFeeDue-t6.CoreRec-t6.LateFeeRec) <> 0 ... Including a order by clause returns 'not a valid currency' error about half the time... eliminating the above solves the problem, but that's not an option. tia, Ben Petersen ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
