I am working with a Microsoft Access Database. There is a table which contains a column called 'City'. This column contains the City, State and Zip in a comma delimited format. I would like to write a query in Access to show the City, State and ZIP as separate columns. These are all locations in the US.
I wanted to see if anyone had any suggestions on how to accomplish this. I have attached a screenshot of the column as a sample.