change double 3 decimal places to 2 decimal places 2

[ksbigfoot]

I have a field of type Double, it originally had 3 decimal places. I changed it to 2 decimal places, but the 3 decimal places are still in the table.

How would I change the numbers to 2 decimal places?

 

[Golom]

Round(TheNumber, 2) - If you want rounding

or

Int(TheNumber * 100#) / 100# - If you just want to chop

 

[ksbigfoot]

Howdy Golom,
Where would I run this code?

 

[JerryKlmns]

Use an update query

UPDATE yourTableName
SET yourFieldName = Round(yourFieldName , 2)

or

UPDATE yourTableName
SET yourFieldName = Int(yourFieldName * 100#) / 100#

 

[ksbigfoot]

Thanks Golom & JerryKlmns,
Makes sense now. Thanks again and star to you both.
ksbigfoot