How to Split One Column into Two in Access Using the Split Function

25-Mar-2020
Have you ever wondered how to split one column up into several columns when you could see that there was a pattern? In this video you're going to learn how to split one column into two or more columns by using the VBA Split function. In our example, we'll use the product code in the Northwind sample database, which has product codes that look like ABCD-123, DEFGA-23, or AB-1. Watch the video to find out how!



Want your staff to have more skills like this? Book a corporate training session today! Contact Us!