Changing format of name field

  • Thread starter Thread starter Pete Provencher
  • Start date Start date
P

Pete Provencher

Using Access 2000:

I have a field called Name that has the name in the following format:

Smith, John A

I would like to change it to:

John A Smith

Can anyone tell me how to do this in a query?


Pete Provencher
 
In the next available coulmn, put this expression in

Mid([Name], InStr([Name], ",") + 1) & " " & Left([Name], InStr([Name],
",") - 1)
 
Thanks. it worked like a charm.

Pete Provencher
JohnFol said:
In the next available coulmn, put this expression in

Mid([Name], InStr([Name], ",") + 1) & " " & Left([Name], InStr([Name],
",") - 1)





Pete Provencher said:
Using Access 2000:

I have a field called Name that has the name in the following format:

Smith, John A

I would like to change it to:

John A Smith

Can anyone tell me how to do this in a query?


Pete Provencher
Click to expand...
Click to expand...
 
Back
Top