Software

Ask something
Discussion Locked

MS Access Update Query

0 helpful
3 replies

by devmann

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have the below data in a field and need to parse out the City and State, leaving only the Zip Code. I would like to know the proper statement to remove this data.
Colorado Springs,CO 80913
Arvada,CO 80005
Denver,CO 802041736

3 replies

by dklippert

Zip : Mid([Address],((InStr([Address],","))+5))

The 5 is for the comma, a space, 2 letters, and a space.

by devmann

Almost exact... it took out one more character than I needed so I change the 5 to a 4 and it worked perfectly.... Close enough for me..... Thanks......

This discussion is closed to new replies.