Good discussion though. I love the adding a negative number bit trick.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, October 08, 2015 8:13 AM
To: MS_Access_Professionals
Subject: 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
Date: 2015-10-08 23:05
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
(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
Date: 2015-10-08 22:05
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
(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
Date: 2015-10-08 21:53
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
(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
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (10) |
Tidak ada komentar:
Posting Komentar