I think you should just go with TRANSFORM.
>Thank you.
>By the way how will this work in Reports?
>There are check boxes for CR if Positive DB if negative or i just have to use TRANSFORM() ?
>
>
>>>>What exactly do you mean here?
>>>
>>>A word to the wise. :)
>>>
>>>In TRANSFORM we can format the data.
>>>
>>>@C Appends CR to positive Currency or Numeric values to indicate a credit.
>>>
>>>@X Appends DB to negative currency or numeric values to indicate a debit.
>>>
>>>I want DB to be DR which is standard for Debit at least in accounting books.
>>>How can i achieve this in VFP?
>>
>>
>>? CHRTRAN(TRANSFORM(-1231,[@X]),[B],[T])
>>
If it's not broken, fix it until it is.
My Blog