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 Rhinorhino 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
Joined
Oct 20, 2004
Messages
321
Location
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
Just to be safe, you might use:

Right(trim({Social_Security}),4)

-k
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

H
  • Locked
  • Question Question
Cannot get a sub-report to print without the headers and footers of the main report
Replies
1
Views
424
DjangMan
DjangMan
Corinne30
  • Locked
  • Question Question
Duplex Printing of Postcard reminders - Not printing back on last page.
Replies
1
Views
659
hilfy
hilfy
RoknRole
  • Locked
  • Question Question
Static parameter list of values limitation
Replies
1
Views
555
RoknRole
RoknRole
dellguy
  • Locked
  • Question Question
Possible to show multiple text values in crosstab as summarized fields
Replies
2
Views
399
dellguy
dellguy
1tufgt
  • Locked
  • Question Question
Creating Chart with formula of running total of group?
Replies
6
Views
640
lbass
lbass

Part and Inventory Search

Sponsor

Back
Top