>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.
Cheers
Terry
- 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.
