Update Query for Replace dashes or hyphen

[doran_doran]

Hyphen or dash whatever you want to call, I need to get rid off it from my social security number. The field name is SSN.

Replace([SSN],"-","",1,12,0) will NOT work because Access 97.

Is there a remedy to replace - with nothing.?

 

[KenHigg]

newssn = mid([ssn], 1,3) & mid([ssn], 4,2) & mid([ssn], 6,3)

???
ken

 

[doran_doran]

hmm, that did not work...

Check out my print screen, May be i have it all wrong. But it's not working. It's prompting for NewSSN.

 

[KenHigg]

Take the brackets off NewSSN


???
ken

 

[KenHigg]

As a matter of fact don't even put it in...

Just the

'mid([ssn], 1,3) & mid([ssn], 4,2) & mid([ssn], 6,3)'

stuff

 

[doran_doran]

...

From SSN,

If I take the bracket of from SSN and then NewSSN is sorrounded by " and after runing the query it replaces all the ssn with NewSSN, the actual wording.

 

[KenHigg]

cut and paste me the code

 

[doran_doran]

Both Method failed....

The last method (SEE ATTACHED PRINT SCREEN) Failed too.

444-55-6666 is now 444-55-66

Any idea ???

 

[KenHigg]

ok mile, what am I missing here...

 

[doran_doran]

Got it....

Mid([ssn],1,3) & Mid([ssn],5,2) & Mid([ssn],8,4)

It's now working with above code. Thanks for all the help and hints.

THANKS THANKS THANKS