insert spaces in string

Joined
Mar 24, 2015
Messages
1
Reaction score
0
I have 100 numeric records in MS Access that need to be converted to string and spaces entered..
for example 38129360 needs to become 38 12 9360. Any advice on querry design?

thanks much
Doug
 
Back
Top