Data Type
I disagree with Ken. Some 'numbers', such as Social Security Numbers,
Zipcodes, and even some phone numbers, can start with zeros. If you store
these in a number field, the leading zeros are removed. Then you need to use
code or fancy formatting to reinsert the zeros before use in something like a
mail merge. There goes any efficiency of storing it as a number.
I say that if your aren't doing math on it, it isn't a number.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
"Steve" wrote:
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
|