SILHOUETE2
Programmer
Hi, I am developing a database in Access 2000 for work and I am having trouble with rounding certain numbers in a specific way. I know that there are ROUNDUP, ROUNDDOWN and MROUND functions available in Excel...do they all exist in Access as well? Or is there an AddIn available somewhere? So far I have only been able to find the Round function and all it does is standard rounding. I need certain fields to always round up to the nearest whole number and I have another field that needs to round up to the nearest 1/8th of an inch. Any suggestions on how I might accomplish this?....Any suggestions would be greatly appreciated!!