10 digit figure


R

Roberto

Hello,

I am trying to import a 10 digit figure from a text file into access. The
field is configured as long integer but it will not import that specific
figure. It crops the last digit.

Should it be a text field instead of a long integer? Any recommendations?
 
Ad

Advertisements

K

Ken Snell \(MVP\)

The largest number that you can store in a Long Integer datatype field is
2,147,483,647 (or -2,147,483,648 for negative numbers). Most likely, your
10-digit number is larger than this.

If you don't mind storing the number as a floating point number, use a
Double datatype field. Otherwise, yes, store it as a Text datatype field.
 
R

Roberto

Ken,

Thanks for your prompt response. Pardon my ignorance, but why would I mind
storing a number as a floating point number? In other words, what does
floating point mean?

Roberto
 
Ad

Advertisements

K

Ken Snell \(MVP\)

Floating point numbers are numbers that can have decimal values (e.g.,
34.56, 1.2567, etc.). Because computers cannot 100% accurately store numbers
to the "nth" decimal place, the number 4 might be stored in the computer as
3.99999999999998. Depending upon how you use the value, this may or may not
cause a problem for you -- for example, if you want to compare this number
to the number 4, you may not get a match; but if you do a calculation, it
may not cause a problem with the result.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top