G
Guest
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
-- that shows only the last 4 of the SSN?
Lou7
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
PC Datasheet
Put the following expression in an empty query field:
LastFourDigits:Right([SSN],4)
LastFourDigits:Right([SSN],4)
J
John Spencer (MVP)
Field: Last4: Right([YourTable].[YourField],4)
SQL Text would look something like:
SELECT Right([YourTable].[YourField],4) as Last4
FROM [YourTable]
SQL Text would look something like:
SELECT Right([YourTable].[YourField],4) as Last4
FROM [YourTable]
G
Guest
I have tried these suggestions and none seem to work. I will keep on trying.
thanks Maybe I am not doing it correct
lou7
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
C
Chris2
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
lou7,
Will you let us in on what did happen when you tried it?
Sincerely,
Chris O.
G
Guest
Got it.
Thanks so very much!
Thanks so very much!
Chris2 said:lou7,
Will you let us in on what did happen when you tried it?
Sincerely,
Chris O.