Changing info in one field to 3 fields

  • Thread starter Thread starter Pete Provencher
  • Start date Start date
P

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
 
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.
 
Took me a little time to figure it out but thanks I got it to work.

Pete Provencher
 
Back
Top