Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: Splitting Data in Access
05-13-2009, 04:10 PM #1
- Join Date
- Mar 2007
- Thanked 2 Times in 2 Posts
Splitting Data in Access
Hi, I need to split some data in access to make a new field, the data format needs to be the first three letters of a product and its ID which is 4 numbers. The problem is how do you take the first 3 letters of the product and join the 2 strings together.