How to de-concatenate mailing address similar to text to column

S

Sherrybesslee

Please advise if you know how to do this in Access similar to what I am doing
in Excel's text to columns but it taking a long time. Thanks!
 
M

[MVP] S.Clark

To de-cat, there must be some kind of logical break. Included in that word
logical is the word consistent, of which addresses are not.

The tools to break apart strings are:

Left()
Right()
Mid()
Instr()
InStrRev()
Replace()

Like any other toolbox, some of these tools are hammners, and others are
Inside Micrometers, so visit the help file for info on each.

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html
 
Top