G
Guest
Hello Access Nation, I'm having a problem rounding up to two decimals. I have
an IIF statement iin my query:
RegAmt:
IIf([Exempt]="Y",-Int(-[AnnualPay]*[Increase_Percent]),Round([PayRate]*[Increase_Percent],2))
It correct rounds the annualpay to a whole number, but payrate needs to
round up to two decimals, e.g., .3117 should round up to .32. The way I have
it now it rounds to .31. I've tried everything I could but I can't get it to
work. Any help that you can give me is greatly appreciated. Thanks
an IIF statement iin my query:
RegAmt:
IIf([Exempt]="Y",-Int(-[AnnualPay]*[Increase_Percent]),Round([PayRate]*[Increase_Percent],2))
It correct rounds the annualpay to a whole number, but payrate needs to
round up to two decimals, e.g., .3117 should round up to .32. The way I have
it now it rounds to .31. I've tried everything I could but I can't get it to
work. Any help that you can give me is greatly appreciated. Thanks