I attempted your suggestions, but it left me with incorrect figures. Apparently it seems to group the totals into other categories or completely leave them out.

>

> select MAX(a.id_no), MAX(a.name), MAX(b.account), b.name, sum(a.inv_total), MAX(a.inv_status) ;
>from customer_invoices a, customer_accounts b;
>where inv_status=lcoverduestatus and a.id_no=gnclientid and a.name=b.account;
>group by b.name ;
>into cursor sql_collections readwrite
>

>fabio