Social Security Numbers

[Guest]

I am working with insurance cards, and due to new regulations we can no
longer print social security numbers. The problem is that some of our
clients only want some of the digits printed to use as an identifier. Other
clients are still printing the full social security number. I need to filter
the data when we receive it to only change certain clients numbers to print a
certain way, such as: XXXXX4190. Is there something I can use to change
this information in my table as we receive orders.

Thanks,

Joe

 

[Douglas J. Steele]

You can use

"XXXXX" & Right(SSN, 4)

If you want this to be permanent, put it into the form's BeforeUpdate event.

 

[Guest]

Thanks for the reply, but I guess my access knowledge is really showing. I
will try to get more specific.
I upload a text file, then pull that information into an access table.
There are two fields that I am using for this question. The first is
TEMPLATE and the second is ID. I want the first five digits to become
"XXXXX" and to display the remaining four only if the template number matches
a specific number. We don't use any forms, and all of our actual templates
link to the table in Access.

I appreciate the code, but I counldn't find where to put it to make it work.

Thank you again,

Joe