Formatting Calculations in Query

C

Craig Walker

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

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]

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
 
Top