UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Last 4 for Social Security Numbers    
 
   
krum35
post Nov 26 2003, 12:16 PM
Post #1

New Member
Posts: 4
Is there a way to have a report format a field for Social Security Numbers so that it only shows the last four?

For Example:

555-55-5555 would read ***-**-5555
Go to the top of the page
 
+
dfitzgibbon
post Nov 26 2003, 12:19 PM
Post #2

UtterAccess Veteran
Posts: 344
From: UK
Look up the LEFT function in help.
df
Go to the top of the page
 
+
MamaBean
post Nov 26 2003, 12:19 PM
Post #3

UtterAccess Addict
Posts: 263
From: Virginia, USA
Create a calculated field with the expression: ="***-**-" & right([SSN])

Substitute [SSN] with the name of your SSN field
Go to the top of the page
 
+
preston
post Nov 26 2003, 12:20 PM
Post #4

UtterAccess Ruler
Posts: 1,692
From: Nevada
Not nitpicking you....just to avoid confusion
Go to the top of the page
 
+
MamaBean
post Nov 26 2003, 12:22 PM
Post #5

UtterAccess Addict
Posts: 263
From: Virginia, USA
oops, you're right, I forgot the most important part!
Go to the top of the page
 
+
dfitzgibbon
post Nov 26 2003, 12:24 PM
Post #6

UtterAccess Veteran
Posts: 344
From: UK
I can't tell my left from my right!!!!!!!
Go to the top of the page
 
+
« Next Oldest · Access Security · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 07:36 PM