What field type other than text can Access hold a 14 digit number?

A

ARYVELLA

just trying to make a table for an ID number thjat is 14 digits long and
don't want to have to use text in less i have too. Information would br
greatly appericated
 
K

kabaka

What's the matter with using text type? If it's disk space you are concerned
with (which would only ever add up to something significant with a large
database) set the field size to 14. So long as you are controlling the input
(i.e. restricting letters for example) this field would "appear" to be a
number type.
 
A

ARYVELLA

it is whole number like : 23650000227970

visual basic searches number data types much faster then text
 
P

Pieter Wijnen

currency ought to do it (all versions)
number(14,0) in newer versions

pieter
 
P

(PeteCresswell)

Per Joseph Meehan:
Yea, I did not read that "ID number" Generally for ID numbers text is
not only as good, but better since you can easily have leading zeros, or add
numbers or spaces; all of which the boss will want next month.
Click to expand...

I'm guessing the 14-digit number is going to be the table's PK.

Has anybody tried using GUIDs for this purpose? Quite a bit bigger, but maybe
easier to use in some cases.
 
P

(PeteCresswell)

Per Brendan Reynolds:
Michael Kaplan has an article on that subject at the following URL ...
http://www.trigeminal.com/usenet/usenet011.asp?1033
Click to expand...

I guess that pretty much settles the question....-)

When I was dabbling in GUIDS, what turned me off was the size of the canonical
presentation. Even though I'd never expose a PK in the UI, it seemed awfully
unweildy for debugging - i.e. manually beating through tables and checking data.
 
Top