Supressing numbers in SS#

[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

 

[Douglas J. Steele]

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)