Changing format of name field

[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

 

[JohnFol]

In the next available coulmn, put this expression in

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

 

[Pete Provencher]

Thanks. it worked like a charm.

Pete Provencher

In the next available coulmn, put this expression in

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

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