General discussion

Locked

Reformat Column in Access

By steve.mallard ·
Need to reformat column with data in it and truncate the first characters of data. Have an access database (XP)with SSN column. Formated as such 111-11-2222. How can I write query, sqlview query to drop the 111-11- and keep the last four....for over 46,000 records?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

This should work

by Tony Hopkinson In reply to Reformat Column in Access

update mytable set ssn = right$(ssn,4)
should work.
Needless to say but back up your file before you discover either of us has made a typeo
PS. As Deepsand often says "Wrong Forum" should be putting this in Technical Q&A

Collapse -

many thanks!!!!!!!!

by steve.mallard In reply to This should work

many thanks!!!!!!!!

Collapse -

Wrong forum

by deepsand In reply to Reformat Column in Access

This is a tech. problem, in search of a solution.

It properly belongs in "Technical Q&A," not in "Discussions."

Please re-post there.

Thank you.

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums