How to split a string in a Microsoft Access Database

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.cityscreenshot.jpg

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder.
But why not let Windows retr…

In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …

Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…