>>OK - I had this done once and (of course) misplaced the solution. I have an A/P invoice table for example that contains invoices and payments. I want to display in a grid only those invoices that are outstanding using a view as the source. So far I've got
>>

>>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)
>></PRE
>>
>>which gives me a 'function name missing ")"' error. What am I missing?
>>TIA
>Hmm the last couple of lines disappeared on the first message.


Bruce,
I haven't tested this, but I moved your final paren to BEFORE the 'Group By' clause.  See if it works.

<pre>
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