> select taxliab.clientno as clientno, ;
> YEAR(taxliab.chkdate) as year, QUARTER(taxliab.chkdate) as qtr, ;
> taxliab.duedate as duedate, ;
> sum(taxliab.amount-taxliab.credtaken-taxliab.removed) as amount, ;
> client.eftpscode as pin, client.fedid as fedid, ;
> lcfirsttaxtype as taxtype, lccode as code ;
> from taxliab, client ;
> where taxliab.clientno == client.clientno and ;
> taxliab.taxtype $ lctaxtype and ;
> taxliab.duedate < = lddate and ;
> taxliab.status == 'P' ;
> group by taxliab.clientno, YEAR(taxliab.chkdate), QUARTER(taxliab.chkdate), taxliab.duedate ;
> order by taxliab.clientno, YEAR(taxliab.chkdate), QUARTER(taxliab.chkdate), taxliab.duedate ;
> into cursor tcdata readwrite
>
>
>
>
>this does not work
You can't GROUP BY a function, you must group by a field name or an ordinal position. So you can't use the YEAR() function, either, you must create afield in your select that has the year in it.