G Guest Oct 15, 2004 #1 I made a calculation in a query that returns a percentage, but it gives me a long decimal format and I want it in percentage...any hints?
I made a calculation in a query that returns a percentage, but it gives me a long decimal format and I want it in percentage...any hints?
V Van T. Dinh Oct 15, 2004 #2 In the DesignView of the Query, select the Calculated column and open the Properties window. In the "Format" row, you can select the "Percent" format.
In the DesignView of the Query, select the Calculated column and open the Properties window. In the "Format" row, you can select the "Percent" format.
B Brett Collings [429338] Oct 15, 2004 #3 Craig, What *exactly* did it return? - The correct value but just with too many decimals? - Sort of the correct value but it was all decimals? Please post the text of the calculation
Craig, What *exactly* did it return? - The correct value but just with too many decimals? - Sort of the correct value but it was all decimals? Please post the text of the calculation
