Long Integer versus Double

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Hi, Paul.
I want to verify I will not lose anything. All my values
are integers up to 12 characters
Click to expand...

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.
 
Thanks for confirming my suspicions. Access Help was not very thorough
regarding datatypes.

Paul
 
Back
Top