Thread: text vs integer
View Single Post
  #3 (permalink)  
Old February 13th, 2007, 10:50 PM
vbark vbark is offline
Registered User
Join Date: Jun 2006
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts

In Access a Long Integer field can store figures up to 2,147,483,647
If there is no formatting issue such as connote's begining with a letter or preceded by a zero then a number field in a database will be smaller to store, take up less space to index, be faster to search and faster when joining by that field in a query.