Subject Re: Total on in dbase 8.0 From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Wed, 7 Oct 2020 17:05:33 +0530 Newsgroups dbase.getting-started On 07.10.2020 15:01, Rouke wrote: > I'm trying to do a simple Total on operation in dbase 8.0, but am not getting results I expect: > > On the following table: > > set fields to typetota = ltrim(str(year(received)))+ltrim(str(month(received)))+testtype > set fields to numbers,received,testtype Good Evening Rouke, I have never used dbase 8 and a little out of touch with xdml hence cannot say with confirmation BUT In the above statements typetota is a string. And how can you expect to total a string field. set fields to typetota = val(ltrim(str(year(received)))+ltrim(str(month(received)))+testtype) may solve your problem. Regards Akshat