Results 1 to 4 of 4
  1. 04-08-2009, 08:28 AM #1
    BigBear
    BigBear is offline Novice
    Windows Vista Access 2007
    Join Date
    Mar 2009
    Posts
    9

    Make Long Integer Field Size show 2.5 Billion

    The largest number I can show with the Long Integer field size seems to be 2100000000.



    I need it to show 2500000000. How can I accomplish this??????
    Reply With Quote Reply With Quote
  2. 04-10-2009, 08:38 PM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    From VBA Help!
    Long Data Type
    Long (long integer) variables are stored as signed 32-bit (4-byte) numbers ranging in value from -2,147,483,648 to 2,147,483,647.
    Reply With Quote Reply With Quote
  3. 04-12-2009, 05:07 PM #3
    BigBear
    BigBear is offline Novice
    Windows Vista Access 2007
    Join Date
    Mar 2009
    Posts
    9

    Solution: Field Size Double

    Thank you for your help.
    I needed it to hold a number larger than 2.2 Billion.
    By changing the field size to Double instead of Long Integer, I was able to accomplish that.
    Thanks again.
    Reply With Quote Reply With Quote
  4. 04-12-2009, 05:11 PM #4
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Glad to hear you got it sorted.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Data won't show up in table field
    By texzen123 in forum Forms
    Replies: 3
    Last Post: 11-26-2009, 11:20 AM
  2. Text field max number as integer in sql query of MS Access
    By kamii47 in forum Queries
    Replies: 1
    Last Post: 10-09-2008, 04:48 AM
  3. I want to make a self generating ID field and other things
    By mabz in forum Database Design
    Replies: 2
    Last Post: 09-01-2006, 04:03 PM
  4. Need to round the decimal portion on a field not the integer
    By admaldo in forum Forms
    Replies: 1
    Last Post: 06-09-2006, 05:44 PM
  5. Yes/No field in a table-Make exclusive or default?
    By Karl H in forum Access
    Replies: 1
    Last Post: 12-09-2005, 09:27 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums