I have a address filed which contains data like this - Jacksonville, FL 32205-9351
I like to be able to separate it into city, state and zip fields.
Sometimes this filed contains only the address like - David Lipscomb University (without city, state and zip)
FYI I do not know VB. Is there anything I can do in Access.
Many thanks in advance.