Bruce,

Try this:

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
>>Barbara
>
>Good thought but when I do that I get a "Subquery is invalid" error.