Switch

M

melissa1005

Does anyone know of a switch that will only put in the last four digits of a
SSN, ie xxx-xx-1234?
 
G

Greg Maxey

Melissa

If the data source format is 123456789, it is relatively simple:
{QUOTE "XXX-XX-"{mergefield ssn \# x### }} or an SSN held as 12345678If the
format is 123-45-6789, it gets more complicated.{QUOTE "XXX-XX-"{SET
ID"{mergefield ssn}"}{SET
SSX{={=-{=-{ID}-ID}/2}-(({ID}*(-1)-{ID})*(-1)/2+{ID})}}{SSX \# 0000}}.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Designate font as italic of another 0
How do I create an Access form that blocks 1st 5 #s of SSN? 1
Multilevel List 3
Right Function in a Report 4
Show last four digits of SS# 3
concatenate entries from a column into a cell by logical AND withanother column 2
Masking Social Security # in a Word merge doc 3
Formatting combo box drop-down list 2

Top