• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1318
  • Last Modified:

Round function in Access 97?

I need to round a number to 2 decimal places. I tried using Round in Access 97 and it seems that it does not exist. Is there another function that will do this?
0
Lisa0812
Asked:
Lisa0812
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
You may have to use CInt(YourValue * 100) / 100 to round YourValue, instead of Round(YourValue,2)

Hope this helps.
-Jim
0
 
Bob LambersonSoftware EngineerCommented:
Dim x
x = 20458.86675
txt1 = Format(x, "##.##")


Bob
0
 
Gustav BrockCIOCommented:
Most round functions are buggy.
Have a look here for proven solutions:

http://www.xbeat.net/vbspeed/c_Round.htm

/gustav
0
 
puppydogbuddyCommented:
Have a look here for a variety of rounding  functions for specific purposes developed for Access97 and Access 2000 by Dr. Roger Carlsten.  All he request is a $1 donation to support the Web site, which has many other useful information, examples and code for Access.  
0
 
puppydogbuddyCommented:
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now