percentage problem

  • Thread starter Thread starter cf
  • Start date Start date
C

cf

I have a report that has 2 columns per detail. Now I am
trying to get a percentage of the two. However, when I
get a continuous percentage it will not limit itself to 2
decimal places that I selected. Here is what I have:


Control Source ="(" & Sum([PointsScored])/Sum
([PointsPossible])*100 & " %)"
Format fixed
decimal places 2

When I get a number like 83.3333333 it does not show as
83.33%.

does anyone have a solution for this?

Thanks in advance
 
Your control source becomes "text" so a numeric format will not work. You
can try:
=="(" & Format(Sum([PointsScored])/Sum([PointsPossible])*100,"0.00") & " %)"
 
thanks works like a charm
-----Original Message-----
Your control source becomes "text" so a numeric format will not work. You
can try:
=="(" & Format(Sum([PointsScored])/Sum([PointsPossible]) *100,"0.00") & " %)"

--
Duane Hookom
MS Access MVP
--

I have a report that has 2 columns per detail. Now I am
trying to get a percentage of the two. However, when I
get a continuous percentage it will not limit itself to 2
decimal places that I selected. Here is what I have:


Control Source ="(" & Sum([PointsScored])/Sum
([PointsPossible])*100 & " %)"
Format fixed
decimal places 2

When I get a number like 83.3333333 it does not show as
83.33%.

does anyone have a solution for this?

Thanks in advance
Click to expand...


.
Click to expand...
 
Back
Top