Update Query

  • Thread starter Thread starter Monica
  • Start date Start date
M

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
 
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
Click to expand...

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")
 
Back
Top