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 SkipVought 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
0
0
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

Stefan11
  • Locked
  • Question
In Windows 11 I do not see main system window although I see command window 3
Replies
8
Views
156
bigrsmith
bigrsmith
kadmathew
  • Locked
  • Question
Hi, I was having some Programs D
Replies
4
Views
74
GriffMG
GriffMG
cfsjohn
  • Question
Can I specify port for InternetConnect 1
Replies
7
Views
548
Chris Miller
Chris Miller
cfsjohn
  • Locked
  • Question
How do I use a particular version of a prg? 1
Replies
2
Views
80
cfsjohn
cfsjohn
BugZap13
  • Locked
  • Question
I need help with a compile error
Replies
9
Views
150
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top