Replace All macro - HELP!

  • Thread starter Thread starter David Peterson
  • Start date Start date
D

David Peterson

Can some one help me write a macro that will perform a "replace all" on one
field in a table.

I have a table that I import. The SSN field has "-" in the number like
123-45-6789.
I need to remove the "-" so the SSN looks like 123456789.

With the table open, I can perform a manual replace all "-" with "".

How can I automate this?
 
David,

Use an Update Query. Update the SSN field to...
Left([SSN],3) & Mid([SSN],5,2) & Right([SSN],4)

- Steve Schapel, Microsoft Access MVP
 
Thank you. That was pretty easy, huh?


Steve Schapel said:
David,

Use an Update Query. Update the SSN field to...
Left([SSN],3) & Mid([SSN],5,2) & Right([SSN],4)

- Steve Schapel, Microsoft Access MVP


Can some one help me write a macro that will perform a "replace all" on one
field in a table.

I have a table that I import. The SSN field has "-" in the number like
123-45-6789.
I need to remove the "-" so the SSN looks like 123456789.

With the table open, I can perform a manual replace all "-" with "".

How can I automate this?
Click to expand...
Click to expand...
 
Back
Top