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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I need to do some rounding.. I hav

Status
Not open for further replies.
jroldan

jroldan

Programmer
Feb 20, 2001
4
US
I need to do some rounding..
I have a database with numbers ranging from .68, 2.94, to 55.97 and so on...
I need to round the numbers to the nearest .09
What type of code do I use to replace the .68 with .69 or 55.97 with 55.99 or the 2.94 with the number nearest to .09?
Thanks in advance
 
Sort by date Sort by votes
Hi,
In this case..

myRoundedNumber = ROUND(myNumber+.01,1)-.01

:) ramani :)
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Filip Brnic
  • Question
Some issues with scroll bars in a form
Replies
3
Views
286
Chris Miller
Chris Miller
Stefan11
  • Locked
  • Question
In Windows 11 I do not see main system window although I see command window 3
Replies
8
Views
325
bigrsmith
bigrsmith
kadmathew
  • Locked
  • Question
Hi, I was having some Programs D
Replies
4
Views
116
GriffMG
GriffMG
cfsjohn
  • Locked
  • Question
Can I specify port for InternetConnect 1
Replies
7
Views
660
Chris Miller
Chris Miller
cfsjohn
  • Locked
  • Question
How do I use a particular version of a prg? 1
Replies
2
Views
135
cfsjohn
cfsjohn

Part and Inventory Search

Sponsor

Back
Top