CREATE SQL VIEW apinquiry AS ; select * from awards!apmaster where apmaster.invoicenum ; in (select apmaster.invoicenum from awards!apmaster ; GROUP BY invoice ; HAVING sum(apmaster.tranamount)<>0 ) ; GROUP BY invoicenum ORDER BY vendornum,invoicenum>>
>>CREATE SQL VIEW apinquiry AS ; >>select * from awards!apmaster where apmaster.invoicenum ; >> in (select apmaster.vendornum, apmaster.invoicenum, >> sum(apmaster.tranamount) as sumamount where sumamount <> 0 >> from awards!apmaster) GROUP BY invoicenum ORDER BY >> vendornum,invoicenum >>>>HTH