Supressing numbers in SS#

  • Thread starter Thread starter SMT
  • Start date Start date
S

SMT

I am trying to suppress the first 5 numbers of a SS#. My goal is t
change a number from ###-##-#### to ####.
I have tried unsuccessfully to create a new mask. Can I use the mas
feature and what would be the format?

Thanks,
Stephani
 
If you've already got the 9 digit number, a mask isn't going to do you any
good: they're only for input purposes.

Create a query based on your table. Instead of the field for the existing
SS#, put a computed field Last4: Right$([SSN], 4)
 
Back
Top