>>>You have to specify the width and the decimal places when using STR(). Try this:
>>>
>>>? STR( SumBooked / SumQuantity * 100,5,2) +"%"
>>>
>>>
>>>Regards
>>>Kevin
>>
>>Good point,Kevin, but you don't need to. That is to be precise about how many sig figs, dec places etc. But an argumentless STR() returns a value OK.
>
>Hi,
>From Help:
>If nLength isn't included, the length of the character string defaults to 10 characters.
>If nDecimalPlaces isn't included, the number of decimal places defaults to zero.
Hi Viv
Sure, but what I meant was: just STR()ing the number does not wipe it out, as happened on my rpt, unless it is less than 0 - it still returns a value. The problem was that I had rpt object property set to format it, which conflicted with the actual value, and I was getting blank values. It's since sorted with a TRANS() and no property formatting.
Thanks for the input.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.