removing dashes from SSN (1 Viewer)

A

aglabrat

New member

Local time

Today, 12:40

Joined

Jan 4, 2013

Messages

4

• Jan 4, 2013

• #1

In my table I use the SSN format. In my query I want the SSN without the dashes. Could someone help with this. I have thought about using Left, Mid, Right, string function but can't find proper usage of these in queries.

Any help would be appreciated.

 

J

jzwp22

Access Hobbyist

Local time

Today, 15:40

Joined

Mar 15, 2008

Messages

2,629

• Jan 4, 2013

• #2

You can use the Replace function as follows:

SELECT Replace([SSN],"-","") as SSNNoDashes
FROM tableanme

 

Isskint

Slowly Developing

Local time

Today, 20:40

Joined

Apr 25, 2012

Messages

1,302

• Jan 4, 2013

• #3

You just need the Replace function.

 

A

aglabrat

New member

Local time

Today, 12:40

Joined

Jan 4, 2013

Messages

4

• Jan 4, 2013

• #4

I may not have explained it well. I do not want to chege the data in my table. I built the query to fill a report. The person wanting the report does not want the dashes in the report.

Thanks for the quick responses and any help you cann give on this

 

pr2-eugin

Super Moderator

Local time

Today, 20:40

Joined

Nov 30, 2011

Messages

8,494

• Jan 4, 2013

• #5

The suggestion provide does not change the data it will show 'AS' SSN with no dashes..

 

A

aglabrat

New member

Local time

Today, 12:40

Joined

Jan 4, 2013

Messages

4

• Jan 4, 2013

• #6

Thanks will try

 

G

Graycom Consulting

New member

Local time

Today, 15:40

Joined

Nov 25, 2019

Messages

1

• Nov 25, 2019

• #7

Try using the replace function in the query. Access has its quirks. Search youtube under my user name. I made a video specifically for this issue.

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 12:40

Joined

Aug 30, 2003

Messages

36,125

• Nov 25, 2019

• #8

This is almost a 7 year old thread. I hope you're not just spamming our forum.

 

vba_php

Forum Troll

Local time

Today, 14:40

Joined

Oct 6, 2019

Messages

2,880

• Nov 25, 2019

• #9

i already reported it as a possibility paul

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 12:40

Joined

Aug 30, 2003

Messages

36,125

• Nov 25, 2019

• #10

vba_php said:

i already reported it as a possibility paul

Click to expand...

Yes, I know. That's why I posted.

 

vba_php

Forum Troll

Local time

Today, 14:40

Joined

Oct 6, 2019

Messages

2,880

• Nov 25, 2019

• #11

pbaldy said:

Yes, I know. That's why I posted.

Click to expand...

so does your title "wino moderator" mean that you are one? I guess I never caught on to that. did that report of mine go to u?

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 12:40

Joined

Aug 30, 2003

Messages

36,125

• Nov 25, 2019

• #12

Just a joke dude. Reports go to all moderators.