>>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.
BTW, you didn't have field in table called Memo, did you? :)
Check your SQL carefully, it contains lots of typos (if it's a real one).
If it's not broken, fix it until it is.
My Blog