Diplaying only the last four of SSNs on a report

[wstylze]

I am attmpting to only display the last for of a SSN in a MS Access 2003 report like so

SSN="****-**-" & right(rstemp("P ersonSSN"),4)

Please assist.

[wstylze]

Thanks figured it out

=Right([PersonSSN],4)

[twinnyfo]

wstylze,

Although you provided a solution that works for you, I am intrigued as to why your first function did not work properly. Assuming that the rstemp was valid and that there was a field named PersonSSN, your code should have worked.

Were you getting an error with the previous code?