Hide partial contents of a column for each record.

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

Guest

How do I make a query column display only part of the fields of a table column?
I have a table which includes social security numbers and I want to create a
column in a table or query that shows only the last four digits of the number
for each record (ie- 123 45 6789 displays: 6789). Thanks for any help you
can provide.
 
Kark said:
How do I make a query column display only part of the fields of a
table column? I have a table which includes social security numbers
and I want to create a column in a table or query that shows only the
last four digits of the number for each record (ie- 123 45 6789
displays: 6789). Thanks for any help you
can provide.
Click to expand...

If it's already a text field...
Right(FieldName, 4)
 
In a new column in your query builder.

Instead of entering an actual field in the "Field:" box, you would enter the
text that Rick Brandt shared with you in the previous post.
 
Back
Top