Hide partial contents of a column for each record.

[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.

 

[Douglas J. Steele]

Right([MyField], 4)

 

[Rick Brandt]

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.

If it's already a text field...
Right(FieldName, 4)

 

[Guest]

Where exactly do you put this command?

If it's already a text field...
Right(FieldName, 4)

 

[Rick B]

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.