Access Equivalent of this Excel VBA Function?

[mccrimmon]

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

[antoka05]

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

[mccrimmon]

That is just the round function that you have provided?