Tue, 22 Jun 2004 04:52:56 GMT

Not sure if this can be done

Code so far in sql query

SELECT  ccln.TYPE, SUM( ccln.measure * ccln.carp ) carp, SUM( ccln.measure *
ccln.prot ) prot, SUM( ccln.measure * (ccln.carp  +  ccln.prot) ) TOTAL
FROM ccln
   INNER JOIN Ord
   ON  (ord.TRANSNO = ccln.TRANSNO)
GROUP BY ccln.TYPE
ORDER BY ccln.TYPE

need to be able to have prot calculate as 0, but still add to summary if
another field value = N. Is this clear enough? Need more info?

--
Janice Whitson
PIT (Programmer-In-Training)
Sar-Net SD Services