Re: Remove numbers from beginning of social security number
- From: John Spencer <spencer@xxxxxxxxx>
- Date: Thu, 26 Jun 2008 11:31:38 -0400
STOP. An update query will REPLACE the data. Since you want to change the display of the information, I would use an expression such as
"***-**-" & Right([SSN Field],4)
Better yet, the following will return a blank if SSN is blank (or null), while the above will return "***-**-".
Format(RIGHT([SSN Field],4),"\*\*\*\-\*\*\-@@@@")
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
CMcGrann wrote:
I have a field that contains a social security number. Due to new privacy laws, we can only display the last four positions. I want to replace the first 5 characters with an asterisk, but leave the dashes and last four numbers as is. Can this be done with an update query?.
123-45-6789 I want to replace with ***-**-6789
- Prev by Date: Re: parameter query
- Next by Date: Copying data from one table to another
- Previous by thread: Re: Remove numbers from beginning of social security number
- Next by thread: Re: Nested SQL Statements causing slowness and errors
- Index(es):
Relevant Pages
|
