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-

Yes, you are right. Sorry for my stupidity.

Good night,

Kevin

Regards,

Kevin Zhao

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

Kevin-

Well, the limit is more than 2 BILLION. Let's be conservative and say the app has to last at least 10 years. There are roughly 3,650 days in 10 years. 2 Billion divided by 3,650 gives you up to 588 THOUSAND requests a day. Do you really think you'll exceed that??!??

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 4:12 PM, 'zhaoliqingoffice@163.com' zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John-
What if the auto key number reach this limit? What do you normally do for handling this problem? As a tour company, we have many requests to send to the suppliers every day, I am afraid this limit will be reached in few years... Thanks.
Regards,
Kevin

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

Yes.

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:59 PM, 'zhaoliqingoffice@163.com' zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

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