How to Reduce Decimal Places?

[lbohen]

In Access 2003, how do I reduce the decimal places in a text field?

For example: 10.406666295 to 10.46.

 

[KARL DEWEY]

Your example is wrong - correct - example: 10.406666295 to 10.40.
Reduced_Decimal_Places: Left([YourTextField], InStr([YourTextField],
".")+2)

 

[Jerry Whittle]

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.