Feb 25, 2003 #1 MHagan Technical User Feb 6, 2002 8 US We created a chart and want to show a percent. However, Access is displaying 50% as 5000%. Any idea, why?
We created a chart and want to show a percent. However, Access is displaying 50% as 5000%. Any idea, why?
Feb 27, 2003 #2 Clifty IS-IT--Management Dec 30, 2002 9 GB A percentage is actually a fraction - divide your calculation by 100. eg =1/2 in general number format would display 0.5 =(1/2)* 100 in general number format would display 50 in precentage format the display would be 50% and 5000% recpectively. Upvote 0 Downvote
A percentage is actually a fraction - divide your calculation by 100. eg =1/2 in general number format would display 0.5 =(1/2)* 100 in general number format would display 50 in precentage format the display would be 50% and 5000% recpectively.