Decimals in Table

[Guest]

Hi,

I have a table that I want to change the fees from two decimals to 3 so that
I can change a fee to 0.005

Each format I try results in this number not being displayed in the table.
It seems to be rounding it off.

 

[John W. Vinson]

Hi,

I have a table that I want to change the fees from two decimals to 3 so that
I can change a fee to 0.005

Each format I try results in this number not being displayed in the table.
It seems to be rounding it off.

What's the datatype of the field? If you view the table in design view and
select the field, what properties are selected in the window on the lower
left: in particular decimal places, input mask and format? Can you get two
decimals but not three - or is it truncating all decimal places (suggesting
that it's the default Long Integer datatype)?

John W. Vinson [MVP]

 

[Guest]

I was able to change it. Made it Decimal, General Number, input mask 0.000. I
think it was fixed somehow. This stuff is always frustrating to me and it
seems to always occur when someone is looking over your shoulder and in a big
hurry.