Update Query

[Monica]

Hi,
I am downloading an excel sheet from an HRIS system,
which includes Social Security Numbers that start with a
0, but are not showing up. What is the formula that I
should use in an update query to ensure that even SS#
that start with a 0 will show up as having 9 digits
rather than 8?
Please help! I forgot the formula.
Monica

 

[John Vinson]

Hi,
I am downloading an excel sheet from an HRIS system,
which includes Social Security Numbers that start with a
0, but are not showing up. What is the formula that I
should use in an update query to ensure that even SS#
that start with a 0 will show up as having 9 digits
rather than 8?
Please help! I forgot the formula.
Monica

It's not so much a matter of the formula as the datatype of the field.
A SS# isn't really a "number" - you'll never do math with it! It
should be stored in a Text field.

If the import (as is likely!) assumes that 003221111 is a Number, you
can use the Format$() function to cast it as a Text:

Format$([SS#], "000000000")