How to add spaces to text string?

[giaruso]

Access 2000. I have table of many hundreds of records. One of th fields of text looks like this: XXXXXXXXXXXX and I want it to look like this: XXX XXX XXX XXX by adding the spaces. Would someone please show me how to write the function or code to add the spaces to the text as shown : Thanks

 

[pbaldy]

For those not wanting to waste their time, this cross-post has been asked and answered on another site.

 

[raskew]

For those not wanting to waste their time, perhaps you could provide a pointer to that other site.

Bob

 

[pbaldy]

Sorry, I felt it was the OP's responsibility.

http://www.dbforums.com/t1191291.html