what is the correct field specification in order to input measurements like 32.15 ?

[Doobiem]

hello all,
I am working on my first access project. have defined some fields as numbers but when i try to input my measurements, it rounds automatically.
any suggestions?
thanks,


Doobie

[isladogs]

Using integer or Long integer will only allow whole numbers
Instead use one of single, double or decimal number datatypes depending on the number of significant digits/decimal places/precision required and whether you need to use that data in further calculations

[Doobiem]

Thanks for the quick response - it works

[Micron]

I've oft read that double is recommended over double

https://www.fmsinc.com/MicrosoftAcce...type/index.htm

[isladogs]

Micron
I'm seeing double.
Unless you have very big numbers or need a large number of d.p., single is often sufficient and would be in this case.
Normally I use double myself but it can lead to floating point errors. For example

X=0.000000000000008
Y=1
?X+Y
 1.00000000000001
?X-Y
-0.999999999999992 

In this example X+Y is rounded but X-Y is not

For more info see
https://docs.microsoft.com/en-us/off...ccurate-result
http://www.net-informations.com/q/faq/float.html

[Doobiem]

Using integer or Long integer will only allow whole numbers
Instead use one of single, double or decimal number datatypes depending on the number of significant digits/decimal places/precision required and whether you need to use that data in further calculations

Hello again,

when I have some fields where decimal digits are of significance (no more than 3 places), and some other when whole numbers are in use, can i define calculations based on mixed field types?
what should the calculated field type be?

Thanks,
Doobie