Taken Part of a Record Field

[Rose]

I have social security number registered in a table with a social security
input mask. For security purposes, I only want to display the first three
numbers of the social security number in a query. --
Rose

 

[KARL DEWEY]

Use a calculated field like this ---
Part_SSN: Left([YourSSNField],3)
Open the query in design view and add the above in the Field Row of the grid.

 

[Jerry Whittle]

SSN3: Left([SSN Field Name], 3)