last first

  • Thread starter Thread starter robyn
  • Start date Start date
R

robyn

I am an end user, not programmer. The database list is
set up for last, first. Suffix names have been deleted,
i.e. sr., or III. How do I a) change to first last, and
b) also put first and last into last.

i.e. smith, rhonda should equal rhonda smith. Also I want
rhonda in field first and smith in field last.

If you could provide exact syntax for update query, that
would be great, so I could copy it directly.
 
I am an end user, not programmer. The database list is
set up for last, first. Suffix names have been deleted,
i.e. sr., or III. How do I a) change to first last, and
b) also put first and last into last.

i.e. smith, rhonda should equal rhonda smith. Also I want
rhonda in field first and smith in field last.

If you could provide exact syntax for update query, that
would be great, so I could copy it directly.
Click to expand...

Actually, you shouldn't have both names stored in any one field,
whether its Last First or First Last.

You should have 2 separate fields in your table.
[FirstName] and [LastName].

Then you can create an update query to separate the names into the two
new fields.

Back up your table first.

Assuming ALL of the names are EXACTLY as you indicate above, i.e. one
Last Name separated by a comma and space from the First Name, you
could use:

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

Change YourTable to whatever the actual table name is.

Then, when ever you need to display the full name, in a form, or
report, use an unbound text control. Set it's control source to:
=[FirstName] & " " & [LastName]
 
Back
Top