|
|
|
#1
04-08-2009, 06:28 AM
|
|||
|
|||
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?????? 
|
|
#2
04-10-2009, 06:38 PM
|
||||
|
||||
|
From VBA Help!
Quote:
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07 If your issue is resolved...follow this link for directions on how to use the Solved thread tool! Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
|
|
#3
04-12-2009, 03:07 PM
|
|||
|
|||
|
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.
|
|
#4
04-12-2009, 03:11 PM
|
||||
|
||||
|
Glad to hear you got it sorted.
__________________
(RG for short) aka Allan Bunch MS Access MVP - WinXP Pro, Win7 - acXP, ac07 If your issue is resolved...follow this link for directions on how to use the Solved thread tool! Teaching is not filling a bucket but lighting a fire. Borrowed quote..."Docendo discimus"
|
|
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Data won't show up in table field | texzen123 | Forms | 3 | 11-26-2009 08:20 AM |
| Text field max number as integer in sql query of MS Access | kamii47 | Queries | 1 | 10-09-2008 02:48 AM |
| I want to make a self generating ID field and other things | mabz | Database Design | 2 | 09-01-2006 02:03 PM |
| Need to round the decimal portion on a field not the integer | admaldo | Forms | 1 | 06-09-2006 03:44 PM |
| Yes/No field in a table-Make exclusive or default? | Karl H | Access | 1 | 12-09-2005 06:27 PM |
Make Long Integer Field Size show 2.5 Billion
Windows Vista 
Access 2007 (version 12.0)
Linear Mode
