>>thanks for fast replay, I made the sql the same you told me but I ound the fields which has value is converted to a (*) otherwise it is 0
>>and this is my code which I have done.
>>
>>mdate1="01/03/2002"
>>mdate2="31/03/2002"
>>mdate1=ctod(mdate1)
>>mdate2=ctod(mdate2)
>Change your SQL to the following (use n number of 0, where n is desired number)
>

>>SELECT Gl.grpcode, Accgroup.grpname, Gl.accno, Gl.macc, Gl.fsacc, Gl.ssacc,;
>>  Gl.tsacc, Gl.desc, Subtrn.debit, Subtrn.credit, ;
>   IIF(Subtrn.debit-Subtrn.credit>0,Subtrn.debit-Subtrn.credit,0000000000) as balancedebit, ;
>>  IIF(Subtrn.credit-Subtrn.debit>0,Subtrn.credit-Subtrn.debit,0000000000) as balancecredit ;
>> FROM  accgroup,gl,subtrn,trans ;
>>   where  Gl.grpcode = Accgroup.grpcode ;
>>   and  Subtrn.srno = Trans.srno ;
>>   and  Gl.accno = Subtrn.accno;
>>   and  Trans.trdate >=mdate1 and  Trans.trdate <=mdate2 ;
>> ORDER BY Accgroup.grpcode,Gl.accno

Exactly what I would have said, but you were faster. Actually, I think 0000000000.00 would be better, because this is finances and they want it precise to the last penny (so they can get away with the millions easier :).