Thread: Data Type
View Single Post
  #2  
Old December 16th, 2009, 03:31 AM posted to microsoft.public.access.tablesdbdesign
Ken Snell
external usenet poster
 
Posts: 177
Default Data Type

Number datatype usually occupies less memory space than text, depending on
the number of digits in the number (as the number of digits increases, text
uses more memory while number uses same amount regardless of digit count).
So go with number.

--

Ken Snell
http://www.accessmvp.com/KDSnell/


"Steve" wrote in message
...
Greetings:

I have numeric data with which I do not need to perform calculations nor
do
I need to sort it. Is it better to store this type of data as a number or
text in terms of the efficiency of the database? Thanks for any thoughts
on
this.
--
Steve