Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

show last four digist of SS # 1

Status
Not open for further replies.
Hueby

Hueby

MIS
Oct 20, 2004
321
0
0
US
Can you use the PICTURE() function, or something else, to only show the last 4 digits of a social security number?

Thanks for any help...

Picture({Social_Security},"_____9999")
 
Sort by date Sort by votes
Right({Social_Security}, 4)

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Corinne30
  • Locked
  • Question
Duplex Printing of Postcard reminders - Not printing back on last page.
Replies
1
Views
70
hilfy
hilfy
RoknRole
  • Locked
  • Question
Static parameter list of values limitation
Replies
1
Views
76
RoknRole
RoknRole
dellguy
  • Locked
  • Question
Possible to show multiple text values in crosstab as summarized fields
Replies
2
Views
62
dellguy
dellguy
1tufgt
  • Locked
  • Question
Creating Chart with formula of running total of group?
Replies
6
Views
124
lbass
lbass
mart10
  • Locked
  • Question
show multiple selections on a parameter in header
Replies
5
Views
89
nicmcd77
nicmcd77

Part and Inventory Search

Sponsor

Back
Top