How to Reduce Decimal Places?

L

lbohen

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

For example: 10.406666295 to 10.46.
 
K

KARL DEWEY

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
dropdown decimal places 4
Number of decimal places output 8
Decimal places in calculated fields 6
Limiting Results to 2+ Decimal Places 4
Format query result as Data Type Number, Field Size Decimal 3
Too many decimal places in Pie Chart 1
Decimal places question 6

Top