If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel Type Rounding
Hello,
Am using A2k. Want to round numbers to thousands. With Excel I use Round(number, -3) for this. However, dont know how to do it with Access standard Round() function. The same syntax produces an error with Access. Pls Help For example, I want 125,232 to be displayed as 125,000 and 125,832 to be displayed as 126,000 TIA Anand |
#2
|
|||
|
|||
Excel Type Rounding
Anand -
Try this: Round([AmountToRound]/1000,0)*1000 -- Daryl S "Anand" wrote: Hello, Am using A2k. Want to round numbers to thousands. With Excel I use Round(number, -3) for this. However, dont know how to do it with Access standard Round() function. The same syntax produces an error with Access. Pls Help For example, I want 125,232 to be displayed as 125,000 and 125,832 to be displayed as 126,000 TIA Anand |
Thread Tools | |
Display Modes | |
|
|