Skip to Content
0
Former Member
Sep 16, 2005 at 08:36 AM

Properties of column values in a query

17 Views

Hi all,

I am interested in knowing, how can we remove the rounding off of a value to its nearest integer, for a selection.

Let me be more clear. I use a variable for alternate unit of measure. When I use some higher unit, then my value is getting rounded off to its nearest integer, rather than showing in the decimals. I have defined 2 decimal places for that selection.

Thank you for your help.