Splitting combine field into separate fields.

[ciarra41]

Trying to split a combine field into separate fields by street, city, state, and zip.

Thanks in advance

Field1
111 MYSTREET DR MYCITY, MYSTATE MYZIP

Field2
888 MYSTREET DR

Field3
MYCITY

Field4
MYSTATE

Field5
MYZIP

 

[dhookom]

Are all of you values formatted exactly the same. For instance how would this address appear

111 S MYSTREET DR ST PAUL, MYSTATE 55212-212


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]