Display Last 4 Digits Error

[JBL]

I have a field in a query that only displays the last four digits of a
person's Social Security # to our staff. It worked great for a year, but all
of a sudden I am the only one that it works for. Any ideas?

Here is the code - SocialSecurity: Right([SSN],4)

The message they are getting is something to the effect of 'Error in Right
Expression'.

Thanks

 

[JL]

H JBL,

Sounds like you are missing your library reference. Since it is working on
your machine. Hit Alt+F11 to open VBA editor. Under "Tools" and
"Reference". To see what you have checked. Then going to the computer that
is not working and make sure they have the same library checked as your
computer.

Hope this helps.

 

[JBL]

Ahh, Bach. Thank you for that. Now getting those back should be fun.

H JBL,

Sounds like you are missing your library reference. Since it is working on
your machine. Hit Alt+F11 to open VBA editor. Under "Tools" and
"Reference". To see what you have checked. Then going to the computer that
is not working and make sure they have the same library checked as your
computer.

Hope this helps.

I have a field in a query that only displays the last four digits of a
person's Social Security # to our staff. It worked great for a year, but all
of a sudden I am the only one that it works for. Any ideas?

Here is the code - SocialSecurity: Right([SSN],4)

The message they are getting is something to the effect of 'Error in Right
Expression'.

Thanks