G Guest Mar 5, 2005 #1 If I have a database with SSNs in it, how can I develop a query -- that shows only the last 4 of the SSN? Lou7
If I have a database with SSNs in it, how can I develop a query -- that shows only the last 4 of the SSN? Lou7
P PC Datasheet Mar 5, 2005 #2 Put the following expression in an empty query field: LastFourDigits:Right([SSN],4)
J John Spencer (MVP) Mar 5, 2005 #3 Field: Last4: Right([YourTable].[YourField],4) SQL Text would look something like: SELECT Right([YourTable].[YourField],4) as Last4 FROM [YourTable]
Field: Last4: Right([YourTable].[YourField],4) SQL Text would look something like: SELECT Right([YourTable].[YourField],4) as Last4 FROM [YourTable]
G Guest Mar 7, 2005 #4 I have tried these suggestions and none seem to work. I will keep on trying. thanks Maybe I am not doing it correct lou7 PC Datasheet said: Put the following expression in an empty query field: LastFourDigits:Right([SSN],4) -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications (e-mail address removed) www.pcdatasheet.com lou7 said: If I have a database with SSNs in it, how can I develop a query -- that shows only the last 4 of the SSN? Lou7 Click to expand... Click to expand...
I have tried these suggestions and none seem to work. I will keep on trying. thanks Maybe I am not doing it correct lou7 PC Datasheet said: Put the following expression in an empty query field: LastFourDigits:Right([SSN],4) -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications (e-mail address removed) www.pcdatasheet.com lou7 said: If I have a database with SSNs in it, how can I develop a query -- that shows only the last 4 of the SSN? Lou7 Click to expand... Click to expand...
C Chris2 Mar 7, 2005 #5 lou7 said: I have tried these suggestions and none seem to work. I will keep on trying. thanks Maybe I am not doing it correct lou7 Click to expand... lou7, Will you let us in on what did happen when you tried it? Sincerely, Chris O.
lou7 said: I have tried these suggestions and none seem to work. I will keep on trying. thanks Maybe I am not doing it correct lou7 Click to expand... lou7, Will you let us in on what did happen when you tried it? Sincerely, Chris O.
G Guest Mar 7, 2005 #6 Got it. Thanks so very much! Chris2 said: lou7, Will you let us in on what did happen when you tried it? Sincerely, Chris O. Click to expand...
Got it. Thanks so very much! Chris2 said: lou7, Will you let us in on what did happen when you tried it? Sincerely, Chris O. Click to expand...