Reformatting a field using an update query (1 Viewer)

[Mookie77]

I have a list a about 1000 usernames. Their
current format is first initial followed by up to 7 digits of their last
name. I need to move the 1st initial to one space after their last name.
example - 'bsmithe' changed to 'smithe b'

Thanks in advance.....
Kyle.

 

[Mookie77]

ok...I think that I have it....simple actually...Query the UserName Column the add a new column to the query:

NewColumn:Mid([UserName],2,7) & " " & Left([UserName],1)

Cool...any better ideas?? I have been out of the Access game for a while....