I have a formula that runs when the user clicks on a certain field on a form in Access 2007. I have the field set in the table as decimal, fixed, 2 decimal places. I have it set the same way in the form. This works fine if I enter the number but how do I fix this field that is connected to the formula. It keeps rounding to the nearest whole number and I need it to round out 2 decimal places.
I have also tried field = round(2,(field1 - field2)) and that gives me a debug error.