L lbohen Oct 5, 2009 #1 In Access 2003, how do I reduce the decimal places in a text field? For example: 10.406666295 to 10.46.
In Access 2003, how do I reduce the decimal places in a text field? For example: 10.406666295 to 10.46.
K KARL DEWEY Oct 5, 2009 #2 Your example is wrong - correct - example: 10.406666295 to 10.40. Reduced_Decimal_Places: Left([YourTextField], InStr([YourTextField], ".")+2)
Your example is wrong - correct - example: 10.406666295 to 10.40. Reduced_Decimal_Places: Left([YourTextField], InStr([YourTextField], ".")+2)
J Jerry Whittle Oct 5, 2009 #3 In a form, report, or query, you can use the Format function. Format(10.406666295, "#0.00") = 10.41 I'm assuming that your 10.46 was a typo. Notice that it rounds up in this case. On problem with the Format function is that it returns a string and not a number.
In a form, report, or query, you can use the Format function. Format(10.406666295, "#0.00") = 10.41 I'm assuming that your 10.46 was a typo. Notice that it rounds up in this case. On problem with the Format function is that it returns a string and not a number.
