Format a Percent

  • Thread starter Thread starter Wendymel
  • Start date Start date
W

Wendymel

I posted a question on 6/24/09 titled "Format a Percent" that was answered
and resolved.

However I have an update to this question. The suggested solution worked
great up until this week when we upgraded to Access 2007. Now I am having
the same exact problem described in June. Please Help....Again!

Thanks,

Wendy
 
Please provide a description of the current problem and what worked in the
older versions of Access.
 
Percent is the result of a calculation between two numbers combined with a
way of expressing that result. And there is no standard complete definition
of that calculation. so it needs verbage to define it.

For example, two numbers, 90 and 100. Here's three of many definitions
of "persentage" for them.

What percent is 90 of 100? 90%
What percent increase is 100 compared to 90? 11.11111%
What percent decrease is 90 compared to 100? 10%

IMHO the table "percent" formatting at the table level is usually worthless
and usually does more harm than good. It automatically enters that answer
to the following question: "Express, as a percentage, the ratio of the
number that you just entered to 1.0000." which is usually worthless and
usually does more harm than good.

So, IMHO, you should not use the % formatting in the table. Figure out
exactly what you are trying to do (including how you want to interpret or use
an entered number) and use other methods (such as display formatting) to put
the % sign after the number.
 
Please provide a description of the current problem and what worked in the
older versions of Access.

If your Access 2003 code did the trick of dividing by 100 any number
= 1, then it won't work in Access 2007, becauase Access 2007 already
does that automatically.

So you can just remove your code and percentage fields should work the
way you expect.

Enter .5 --> get 50%
Enter 50 --> get 50%

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
Back
Top