00003 Keeping the zeros

[Guest]

We are using 1st 5 digits of SS#'s to use as the primary key for records of
people. However, if the person's SS# starts with a zero, Access removes it.
Is there any way to force it to keep the zeros? I tried changing it to a text
field, but it gave me a warning that all information would be lost if I did
that. The field is currently an Integer.

 

[Guest]

Ken answered your question. I have my own for you: What are you going to do
when you have another person with the same first five characters of the SSAN
or no SSAN at all? Better to think about it now than later when it happens.