how can I change a field to have dashes, (ie social security no.)

[D Henderson]

I want to change the numbers, which are social security numbers, in a field
to have the dashes in the correct places. Right now the data type I have for
this field is number.

 

[Ofer Cohen]

I'm not sure on the right format you are looking for, but you can use a query
to return the data in the right format


NewFieldName: Format([YourFieldNAme],"##-######")

 

[FD]

Hi

U need to specify the Input Mask of the number "##-####".. or whatever
is the format. Keep the data type of the field as number.

 

[Jerry Whittle]

Social Security Numbers aren't really numbers and shouldn't be stored that
way. Do you have any SSN's for people who got them in the upper New England
area? If you are storing them as a number, the leading zeros are missing.
Same goes for Zip Codes.

You can use the following format to display the dashes and leading zeros
with your existing numbers:
000-00-0000