I want the first four characters from a field...

[wh00t]

I have an annoying database and I would like to do some detailed 'stuff' with a field in a table.

I would like to split the field into parts as each part represents certain information.
eg - 175393843

I would like to split into seperate fields
eg - 1753 - 938 - 43

I would like this done through an append query so that I can split many records at once.

I have completely forgotten the comands to dig out characters from fields so my searches have been like looking at a where's wally book!

 

[Newman]

FirstPart:LEFT([...],4)
MiddlePart:RIGHT(LEFT([...],7),3)
LastPart:RIGHT([...],2)

 

[antomack]

Need to use Left, Mid and Right functions

Left([YourFieldName],4) - first 4 characters
Mid([YourFieldName],5,3) - 5th, 6th and 7th characters
Right([YourFieldName],2) - last two characters

Keep in mind that if your fields are not all of same length then the above would lead to inconsistencies in your data.