How to stop numeric column from truncating a zero at end of a number?

[skhoury]

Hello all - I am totally new to Access and DBs all together, so I appoligize for my simple question but...

I have a simple table with only 3 colums.

One of the columns is a numeric field with 6 digits to the right of the decimal place.

If the number is the following: 16.117070, it only records 16.11707...truncating that last zero.

How can I get it to stop doing that?

Any help is greatly appreciated, thanks all!

Sam

 

[PHV]

A number is a number, i.e. 16.117070 = 16.11707 = 16.11707000 !
You may consider a display format like "0.000000"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[skhoury]

The display format did it.

Thanks,

Sam