Split column data to two columns

[willbost]

I have a field "Client-Dept" that contains the following type of data:

00-825
00-4255
00-588

I want to create a query that takes this field and spits into a Client field and Dept field.

For client, I am using the "Left([Client-Dept],2)" But since the Dept field varies on length, I cannot use the "Right" function. Somehow I need to split and get the data after the "-".

Thanks!

 

[boblarson]

Use the MID function:

Mid([Client-Dept], Instr(1, [Client-Dept], "-") + 1)

(the function takes 3 arguments but I used two as the last argument is optional so if you leave it off it takes the remainder of the text after the starting point.)

 

[willbost]

Thanks! I tried the Mid function, but obviously was doing it wrong.