+ Reply to Thread
Results 1 to 3 of 3

Access Equivalent of this Excel VBA Function?

  1. #1
    Forum Contributor mccrimmon's Avatar
    Join Date
    02-19-2004
    Location
    Scotland
    MS-Off Ver
    2003
    Posts
    249

    Access Equivalent of this Excel VBA Function?

    Is anyone able to help with the below:

    I need the equivalent Access Function for the below Excel Function
    I know it might not be the right place to ask, but im really lost for ideas?


    Please Login or Register  to view this content.
    I had this function in Access, however, it is not watching the results of the Excel Function for the following prices:

    0.70495 is becoming 0.7049 rather than 0.705 and 0.40545 is becoming 0.4054 rather than 0.4055


    Please Login or Register  to view this content.
    Any help would be greatly appreciated.

    Thanks
    McCrimmon

  2. #2
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628

    Re: Access Equivalent of this Excel VBA Function?

    You can use the Evaluate instruction also in Excel but I think (perhaps erroneously) that ronud instruction is running, try with this code:
    Please Login or Register  to view this content.
    Regards,
    Antonio

  3. #3
    Forum Contributor mccrimmon's Avatar
    Join Date
    02-19-2004
    Location
    Scotland
    MS-Off Ver
    2003
    Posts
    249

    Re: Access Equivalent of this Excel VBA Function?

    That is just the round function that you have provided?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1