Log in

View Full Version : Solved: ROUNDING UP NUMBERS VIA A FORMULA IN A CELL


GaryB
08-29-2012, 03:58 PM
I have looked in the knowledge base and have seen that Access, my version being 2000, does not round up number like excel can. The only fix for this I found was to write a code and attach it to a command button. For my purposes this is just not going to work. Does anyone know of a way to write a formula in a cell and make this happen?

Thanks,

Gary
GaryB
08-31-2012, 01:49 PM
Here is how to do it:

=-Int(-[myfield]/[myfield])
works with *, /,+,-