Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2009

    Unanswered: Large Numbers in Number field


    I am trying to import some very large numbers into my access database. The field I am trying to import it into is marked as a long integer. Unfortunatley it does not accept my numbers which are in the billions. What can I do?????? converting into text does not help since I need to do calculations with it.

  2. #2
    Join Date
    Jun 2007
    Maitland NSW,Australia
    Change the Data type of the field from Long Integer to DOUBLE.

  3. #3
    Join Date
    Feb 2004
    One Flump in One Place
    Poppa Smurf is not wrong, however I am going to suggest DECIMAL. Set the precision to the total number of digits required by your number (e.g. for a million it would be 7) and set the scale to 0.

    The reason is that DOUBLE is an imprecise, scientific data type. It will not make any difference for you if your numbers are whole numbers only however I am on a bit of a mission to encourage use of DOUBLE only when it is necessary (which is surprisingly rarely).
    pootle flump
    ur codings are working excelent.

  4. #4
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    You gotta love a man on a mission!
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts