Round function in Access 97?

Posted on 2005-05-02
Last Modified: 2008-01-09
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?
Question by:Lisa0812
    LVL 65

    Accepted Solution

    You may have to use CInt(YourValue * 100) / 100 to round YourValue, instead of Round(YourValue,2)

    Hope this helps.
    LVL 12

    Expert Comment

    Dim x
    x = 20458.86675
    txt1 = Format(x, "##.##")

    LVL 48

    Expert Comment

    by:Gustav Brock
    Most round functions are buggy.
    Have a look here for proven solutions:

    LVL 38

    Expert Comment

    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.  
    LVL 38

    Expert Comment


    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now