>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.
Calltype is not in the FROM clause.
DESC being a keyword makes no difference.
Insanity: Doing the same thing over and over and expecting different results.