Changing info in one field to 3 fields

[Pete Provencher]

Using Access 2000:

I have a single field that contains the city, state, and zip.

Example:

Conway, SC 29566
Surfside Beach, SC 29588-5678
North Myrtle Beach, SC 29511

What I would like to do is break the info out into 3 separate fields. I
thought of using left, mid, and right function but the data sizes don't
accommodate their use.

Can someone suggest a way to perform thi task

 

[Van T. Dinh]

Left, Mid and Right functions work fine but you need to use InStr() and
possibly InStrRev() to work out where to break the String.

Check Access VB Help on the above function.

 

[Pete Provencher]

Took me a little time to figure it out but thanks I got it to work.

Pete Provencher