Adding a space in Access

[Bill]

I would like to add a space to separate a row of numbers in a table;
What I have is: 1234567890
What I need is 12345 67890
Any help will be appreciated.
Thanks

 

[BruceM]

In a query, create a new field:
NewField: Left([YourField],5) & " " & Right([YourField],5)

You could do the same thing in a text box. Set its Control Source to:
=Left([YourField],5) & " " & Right([YourField],5)

You could run an update query if it is essential for some reason that the
space be stored in the record, but based on what you have provided that is
not necessary.