Round percentages in queries

  • Thread starter Thread starter Tyler at Creme
  • Start date Start date
T

Tyler at Creme

How do I apply a round to Format([RegHrs]/[OTHrs], "Percent") so that I get
99% instead of 98.64%?
 
How do I apply a round to Format([RegHrs]/[OTHrs], "Percent") so that I get
99% instead of 98.64%?
Click to expand...

Format(Round([RegHrs]/[OTHrs], 2), "Percent")

Round to two decimals (0.9864 becomes 0.98) and then format.
 
You must log in or register to reply here.

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

Percentages 1
Total Monthly Average box 2
Automatic rounding? 1
Non-printable characters in query results...why ? 13
Percentages Total 3
Access Test if value is less than percent 0
Do not round percentage 1
Rounding Decimals 14

Back
Top