Formatting Calculations in Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Group by precinct, calculate percentage of older voters 0
Access Test if value is less than percent 0
Total Monthly Average box 2
Query not giving right percent decimal 7
List Box Percentage Formatting 3
percentage calculated shows in form, but not in report 1
Calculations in Group Footer 7
Can a function return more than one value ? 1

Back
Top