Separate a numerical column

[Emaleth]

Hiya - I have a column in that contains a 9 digit number that I need to separate into 3 separate columns with 3 numbers each.

COLUMN A = 000000000

I need three columns to look like:

Column B = 000
Column C = 000
Column D = 000

Can this be done thru the query screen and if so, can someone please help with me the formula to do this?

Much obliged.

 

[alansidman]

Take a look at this tutorial. I think that you will be able to achieve your expected results after viewing this.

http://www.datapigtechnologies.com/flashfiles/datamanipulate.html

Alan

 

[Emaleth]

Fabulous "how to" Much Much Much thanks!!!!!!