Rounding Issue

[JoseSharp]

Hi all, I have a d'base that performs calculations within queries. These queries are formated to show amounts with only two decimal places. Within the process there are VBA controls surrounding these calcualtions. The controls are not working due to the VBA showing an unformated calculation. For example, if we say the calculations on the query are 10.50 and the calculation code is

If !F34 > !F33 Then

Now when I stop the code and hold the cursor over either F34 or F33 (the calculations fields) I see the d'base is showing amounts like 10.50123456 and 10.501234.

Does anyone know of any VBA code that I can run before 'If !F34 > !F33 Then' so the VBA can be rounded

 

[pbaldy]

Formatting how they show doesn't change the underlying number. Try the Round() function.