Long Integer versus Double

[Guest]

I want to switch datatypes from Double to Long Integer to about decimals in
my export to text, but when I attempt to switch I am warned about using a
shorter datatype. I want to verify I will not lose anything. All my values
are integers up to 12 characters,

Paul

 

['69 Camaro]

Hi, Paul.

I want to verify I will not lose anything. All my values
are integers up to 12 characters

Don't convert the data type to Long. A Long data type can only hold values
from -2,147,483,648 to 2,147,483,647 (signed). 12 digits means you need to
hold up to 999,999,999,999 (or 1 less than 1 trillion), which is quite a bit
larger than +/-2.147 billion.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Guest]

Thanks for confirming my suspicions. Access Help was not very thorough
regarding datatypes.

Paul

 

['69 Camaro]

You're welcome. I don't know why the range of numbers isn't included in the
online help. It's important to know these things.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.