Numeric data types

[dfuas]

Hi,

Strange but true.
I am trying to numeric data types on my access 2000 where I could input values in table like 0.3567 or 2.3454
Anyway any values of this kind with 4 decimal places. however somehow the values always get rounded to number + 4 zeros as of example:
if I put 0.756769 I want it to be as 0.7568 but I get 1.0000
I don't understand this. Can anyone help please?
I have not used access for ages and I seemed to be forgeting all this stuff.

Thanks

dfuas

 

[Bat17]

you need to set the datatype in the fileds properties to double or single depending on how big the numbers could get.

Peter

 

[dfuas]

thanks a lot.
dfuas