00003 Keeping the zeros

J

jkjmwilliams

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.
 
J

Jerry Whittle

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

keeping zeros 4
Adding recognised Zeros 5
Zeros drop when exporting into Access 5
Holding the zeros 4
Leading Zeros 6
Adding Zeros 7
Droping Leading Zeros In Table 2
convert large text to large number 5

Top