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

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

Guest

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?
 
Thanks. Where should I place this, in the report or query or what? I have
tried several locations and it isn't working.

Duane Hookom said:
Right([ssn],4)

--
Duane Hookom
MS Access MVP
--

Randy said:
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?
Click to expand...
Click to expand...
 
"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
--

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

Duane Hookom said:
Right([ssn],4)

--
Duane Hookom
MS Access MVP
--

Randy said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Thanks for the help. I figured out where to put the info.

Duane Hookom said:
"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
--

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

Duane Hookom said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top