how do I show part of a field on a report in access?

[Randy]

I use social security numbers in my database. I want to show only the last 4
digits of the number on my reports for security reasons. How do I?

 

[Duane Hookom]

Right([ssn],4)

 

[Randy]

Thanks. Where should I place this, in the report or query or what? I have
tried several locations and it isn't working.

Right([ssn],4)

--
Duane Hookom
MS Access MVP
--

I use social security numbers in my database. I want to show only the last
4
digits of the number on my reports for security reasons. How do I?

 

[Duane Hookom]

"it isn't working" does not tell us much.
You can set the control source of a text box to:
=Right([Your ssn field name],4)
Make sure the name of the control is not the name of a field.

--
Duane Hookom
MS Access MVP
--

Thanks. Where should I place this, in the report or query or what? I
have
tried several locations and it isn't working.

Right([ssn],4)

--
Duane Hookom
MS Access MVP
--

I use social security numbers in my database. I want to show only the
last
4
digits of the number on my reports for security reasons. How do I?

 

[Randy]

Thanks for the help. I figured out where to put the info.

"it isn't working" does not tell us much.
You can set the control source of a text box to:
=Right([Your ssn field name],4)
Make sure the name of the control is not the name of a field.

--
Duane Hookom
MS Access MVP
--

Thanks. Where should I place this, in the report or query or what? I
have
tried several locations and it isn't working.

Right([ssn],4)

--
Duane Hookom
MS Access MVP
--

I use social security numbers in my database. I want to show only the
last
4
digits of the number on my reports for security reasons. How do I?