If Then questions about regions of the country
I want to make a field in my database that returns Mid-West if the State_Province1 is a mid-west state (like maybe Indiana). Or, returns North East if the state is maybe New Hampshire. How can I do this? Any help would be greatly appreciated.