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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine Multiple tables into One Master table 1
Formatting a Combo box 12
Masking Characters 6
Convert Text field to Number Field 3
Some of my SSN's are being treated as formulas 12
07 Pivot Table side by side row labels 3
What is the field switch to display a SSN properly? 3
Finding count of unique number within a specific criteria? 7

Back
Top