Hello,

The following query returns all records including those with
a zero sum(glt_total) the HAVING should be discarding them:

select glt_group, sum(glt_total)
from gltrans
where glt_actperiod >= 200801
group by glt_group
having sum(glt_total) <> 0
order by 2


Also, it appears that if I change to <> to < then
it will return records that are less than zero
and equal to zero.

If I change to <> to > then it will return records
that are greater than zero and equal to zero.

I am using Firebird version 2.1.1.17910 on an XP computer.

Thanks
Michael Horne