the following sql is not working . If sum(salary) = null should be displayed 1 or 0 select empname,iif((isnull(sum(salary),0)),1,0) from salary group by empname regards Pol polachan