Splitting Data in Access

[tyanque]

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.

Thanks,

Tyanque