RE: QofQ and negative numbers

2002-09-30 Thread Stacy Young
Nevermind! Was a "user" problem :-) -Original Message- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 12:58 PM To: CF-Talk Subject: QofQ and negative numbers I've got a oracle db query that returns a recordset with an amount column which c

QofQ and negative numbers

2002-09-30 Thread Stacy Young
I've got a oracle db query that returns a recordset with an amount column which can sometimes be a negative value. I then have a QofQ to extract a portion of data that uses SUM(amount)...It appears to be ignoring the fact that some amounts are negative and it's giving me a total as if they're all