Round percentages in queries Tyler at Creme 12/30/2008 12:14:01 AM How do I apply a round to Format([RegHrs]/[OTHrs], "Percent") so that I get 99% instead of 98.64%? -- Tyler at Creme New Access User

Re: Round percentages in queries John W. Vinson <jvinson[ at ]STOP_SPAM.WysardOfInfo.com> 12/30/2008 12:23:46 AM On Mon, 29 Dec 2008 16:14:01 -0800, Tyler at Creme <TyleratCreme[ at ]discussions.microsoft.com> wrote: [Quoted Text] >How do I apply a round to Format([RegHrs]/[OTHrs], "Percent") so that I get >99% instead of 98.64%? Format(Round([RegHrs]/[OTHrs], 2), "Percent") Round to two decimals (0.9864 becomes 0.98) and then format. -- John W. Vinson [MVP]