>Thanks Trey
>
>>Desc is a keyword (DESC[ENDING]) - maybe that's what's doing it.
>>If not, could you post the SELECT statement?
>
>select allt(calledto.calledfn)+" "+allt(calledto.calledmn)+" "+allt(calledto.calledln) as name, timelog.calleddate as date, timelog.calledduration as duration, timelog.memo,calltype.desc ;
> from timelog, calledto ;
> where timelog.noted =.F. ;
> and timelog.calltype = calltype.id ;
> and timelog.calledto = "000001" ;
> and calledto.id = timelog.calledto ;
> and between(timelog.calleddate,{^2000/01/01},{^2000/12/31}) ;
> into cursor sqlrpt ;
> order by name, date
>
>Except it's CALLTYPE.DESC instead of service.desc.

Hi Andy,

You didn't use calltype table in your from expression. You use only timelog and calledto. This is the problem, besides DESC.