Sum only positive values

G

gatarossi

Dear all,

In my table the values can be positive or negative. I'm trying to do a
consult to sum only the positive values... How can I do it?

Thanks in advance!

André.
 
P

Pieter Wijnen

Add the field to the query once more, remove the show flag & enter the
condition

ie

SELECT Sum(MyFieldd) AS TheSum
From MyTable
Where MyField >0

HhH

Pieter


Dear all,

In my table the values can be positive or negative. I'm trying to do a
consult to sum only the positive values... How can I do it?

Thanks in advance!

André.
 
Top