>>UI have 2 rpt vars: SumBooked and SumQuantity
>>SumBooked is set to calculate sum of Bookedcolumn
>>SumQuantity is set to calculate sum of Quantity column
>>The following happily prints the %age:
>>
>>SumBooked / SumQuantity * 100
>>
>>But when I convert it thus:
>>
>>STR( SumBooked / SumQuantity * 100) +"%"
>>
>>all I get is the decimal point.
>>
>>What am I missing here?
>>
>>'ppreciate it
>>
>>Terry
>
>Not enough room? What about Transform( SumBooked / SumQuantity * 100) +"%
Well, now 94.17 becomes 94..17 and the "%" doesn't show.
Not enough room is not the reason, as I have already tried expanding the field, but if it is a long string of *************** then what can you do.
- 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.