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

Good thought but when I do that I get a "Subquery is invalid" error.