Sum only positive values

[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é.

 

[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é.