I've got a view that's feeding an Access form. Although I'm using Round(field,2) for output I still get the trailing zeros that correspond to the original field precision. What I need is something akin to Oracle's Truncate, that actually gets rid of unwanted precision.
Is there a way to do this without a cumbersome string convert/parse approach? (I've tried using the FORMAT within Access but it doesn't seem to recognize what's coming at it correctly.)
TIA
Is there a way to do this without a cumbersome string convert/parse approach? (I've tried using the FORMAT within Access but it doesn't seem to recognize what's coming at it correctly.)
TIA