format SSS#

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to print the last four digit of SSS# in the report. How will I do this?
(e-mail address removed)
 
Have you tried Right([YourSSNField]),4) ?
I want to print the last four digit of SSS# in the report. How will I do this?
(e-mail address removed)
 
Or maybe:
"...-..-" & Right([YourSSNField]),4)
I want to print the last four digit of SSS# in the report. How will I do this?
(e-mail address removed)
 
I want to print the last four digit of SSS# in the report. How will I do this?
(e-mail address removed)

In an unbound text control on your report:
=Right([SSN],4)
 

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

Back
Top