I have a field that stores 8 decimals, but I want to select this field in a query with the decimals rounded up to the fifth. The rounding up should always occur, even if the number is below five. For example:
83.00381433 rounds up to 83.00382000
I've played around with the CEILING function, but I'm not sure how to make it apply to the fifth decimal place.
Any help would be greatly appreciated!