add a space between set characters

[Monica]

I would like to add a space between the 2nd and 3rd
character in a field for all records in a table. I
believe this can be done through a string command, but not
sure how. An example of what I'm trying to do is:
"MW2-16" and I need it to read "MW 2-16"

Thanks

 

[Michael Hopwood]

This UPDATE query should do it:

UPDATE MyTable SET MyField = Left(MyField,2) & " " & Mid(MyField,3,999);

 

[R. Hicks]

Create an Update Query and us the following as the "Update To" valu
...

Left([FieldName],2) & " " & Mid([FieldName],3)

RD