Update query doesn't show correct format

[Guest]

I'm using an update query to perform a calculation. The result of the
calculation contains 2 decimal places (xx.yy). I successfully update my table
with the calculation result, but the table seems to round the result to a
whole number (i.e 84.01% rounds to 84.00%).

Background;
My query update column properties show format as PERCENT and decimal place
as 2.
My table field properties show data type as NUMBER, Field size as DECIMAL,
Field format as PERCENT, Percision as 6, Scale as 2.
Current output shows as 84.000%

How do I get the table to hold the field format as a 2 decimal place number
(i.e 84.01%)?

Thanks.

 

[[MVP] S.Clark]

The format of a field, and it's actual value may differ. Try expanding the
column width of the data grid to see what I mean.