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.
 
Back
Top