Do not round percentage


Robbie Doo

Everyone is talking about rounding up or down the percentage. What about if
you don't want to round it?
I want the number to show 99.99% or 100.01% instead of 100.00%.
How can I do that?



Jeff Boyce

If you tell Access how many decimal places to display, AND if you tell
Access how many decimal places to STORE (field data type), you can see as
many as you want.


Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer

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

Rounding Percentage 4
not rounding percentages 1
Access 2007: % fields rounding to nearest integer 3
Percents to Total 100 1
News CES 2019 round up 6
Percentages 1
Rounding up! 2
Rounding a numner in a query 1