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

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___