Syntax assistanc requested for [last,first] conversion

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field containing [lastfirst] which I want to
switch into [first] and [last]. I need syntax assistance
for an update query which I can paste.

Data is

Existing Want it to Be 2 fields
last first
Smith, John [smith] and [john]
Stewart, Martha R. [Stewart} and [Martha R]

Am using ACcess 2000 and Windows 2000.
Thanks for any help.
 
I have a field containing [lastfirst] which I want to
switch into [first] and [last]. I need syntax assistance
for an update query which I can paste.

Data is

Existing Want it to Be 2 fields
last first
Smith, John [smith] and [john]
Stewart, Martha R. [Stewart} and [Martha R]

Am using ACcess 2000 and Windows 2000.
Thanks for any help.
Click to expand...

If all the records are in the identical order...
LastName comma space FirstName and Initial:

Update YourTable Set Yourtable. LastName =
Left([FullName],InStr([FullName],",")-1), YourTable.FirstName =
Mid([FullName],InStr([FullName],",")+2);

Change the table and field names as needed.
 
Back
Top