>thanks - I gues I've been trying to avoid the 'string conversion and back' tricks - was hoping forsomething more native to SQL and numbers.
>Thanks for replies!
>Ken
>
>>This is untested, but would val(str(qty*price, 14, 4)) return the proper digits?
Ken,
I've just tried this (fpw26) and I think you'll need DECIMALS set to 4 to get the output you want - otherwise the VAL() will trim it back to 2 decimal places.
regards
Ian