By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

Parsing a number

P: 10
I have a database with a social security number field that contains the 9 digit number without hypens. I would like to create a field using a query that just has the last 6 digits of the social security number. Is there a way to do that? Thanks!
Dec 7 '07 #1
Share this Question
Share on Google+
5 Replies


Rabbit
Expert Mod 10K+
P: 12,382
Use the Right() function.
Dec 7 '07 #2

P: 10
Thanks. However, I hate to seem stupid, but how do I do that?
Dec 7 '07 #3

missinglinq
Expert 2.5K+
P: 3,532
In the Design Grid for your query, assuming it contains the aforementioned SSN field, in a blank field box type:

LastSixSSN: Right([SSN],6)

Welcome to TheScripts!

Linq ;0)>
Dec 7 '07 #4

P: 10
Thank you so much! I really appreciate your help.
Dec 8 '07 #5

missinglinq
Expert 2.5K+
P: 3,532
Glad we could help!

Linq ;0)>
Dec 8 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.