format SSS#

Thread view:

Thread rating:

jay - 16 Jul 2007 21:16 GMT

I want to print the last four digit of SSS# in the report. How will I do this?
jdejesus_usa@yahoo.com

ruralguy - 16 Jul 2007 21:43 GMT

Have you tried Right([YourSSNField]),4) ?

>I want to print the last four digit of SSS# in the report. How will I do this?
>jdejesus_usa@yahoo.com

Signature

HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

ruralguy - 16 Jul 2007 21:44 GMT

Or maybe:
"...-..-" & Right([YourSSNField]),4)

>I want to print the last four digit of SSS# in the report. How will I do this?
>jdejesus_usa@yahoo.com

Signature

HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.

fredg - 16 Jul 2007 21:45 GMT

> I want to print the last four digit of SSS# in the report. How will I do this?
> jdejesus_usa@yahoo.com

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

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail