how to format percentage in access report

[mdnikki]

For the life of me, I know I have done this before but for some reason the formatting looks terrible.



I am doing this in a report obviously. I have two fields CountOFAppeal Description and Amount Solicited.

I just want to get the percentage of response.

So this is what I used:

=[CountOfAppeal Description]/[Amount Solicited]*100

When I go into the properties to format it to % and add decimal places I get a crazy number
2520.46% When it should be 25.20%

When I change the format to general number the decimal point is in the right place 25.20.

Any help is appreciated.

[pbaldy]

It's not a crazy number, it's the result of multiplying by 100.

[pbaldy]

Closing this thread due to duplicate question:

https://www.accessforums.net/access/...rly-32390.html

Please don't post the same question twice.