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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top