ACCESS FEED: Re: Re: [MS_AccessPros] Doesn't allow longer digits in the number field

Kamis, 08 Oktober 2015

Re: Re: [MS_AccessPros] Doesn't allow longer digits in the number field

John-

Does this mean the largest auto key number is the same as 2,147,483,647? Thanks

Kevin

Regards,

Kevin Zhao

From: John Viescas JohnV@msn.com [MS_Access_Professionals]
Date: 2015-10-08 21:53
To: MS_Access_Professionals
Subject: Re: [MS_AccessPros] Doesn't allow longer digits in the number field

Kevin-

The largest number you can store in a Long Integer is 2,147,483,647. If you need to store bigger integers, use Decimal.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

On Oct 8, 2015, at 3:38 PM, 'zhaoliqingoffice@163.com' zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Dear All,
I have a number filed in Long Integer. My problem is that this field doesn't allow me to input more than 10 digits. What I have to do? Thanks in advance.

Regards,
Kevin Zhao