I have a field which needs to round up. It currentl rounds to the nearest whole number, is there a simple command to achieve this?
TIA Cliff
TIA Cliff
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
format for round up command help reqd pls 1
- Thread starter CliffordTheRedDog
- Start date
- Status
-
1
- #2
You could try:
You may want to use Fix instead if your numbers might be negative.
[blue]"Well, once again my friend, we find that science is a two headed beast. One head is nice, it gives us aspirin and other modern conveniences,...but the other head of science is BAD! Oh, beware the other head of science, Arthur; it bites!!" - The Tick[/blue]
Code:
nRounded = Int(nNotRounded) + 1[blue]"Well, once again my friend, we find that science is a two headed beast. One head is nice, it gives us aspirin and other modern conveniences,...but the other head of science is BAD! Oh, beware the other head of science, Arthur; it bites!!" - The Tick[/blue]
- Thread starter
- #3
TomThumbKP
Yup that did it, thanks a lot.
regards
Cliff
Yup that did it, thanks a lot.
regards
Cliff
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
