Supressing numbers in SS#

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
 
D

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