Reducing the after decimal digits

[razimars]

I have a table in which i have fields that have numbers with a huge number of digits after the decimal. i.e 10.2356491876545.... when i change the properties of the field to show only two digits. it does display two digits but the number is still stored in its original format. Is there anway i can chop off the unwanted digits forever so that they are not stored in the table anymore.

 

[RuralGuy]

There are several options here. A Currency data type only stores up to 4 decimals for starters. If you use the Round() function when you store the value then you can control the decimals that way.

 

[razimars]

Hey buddy,

Thnx for the response, I need to round it to one digit, unfortunaly the company i work at is still using Access 97. I tried using the round function and it does not recognize it. So i assume the round function was built for later versions of Accesss.

 

[RuralGuy]

[YourField] = Int([YourField]*10)/10
...should do the job for you.