Reverse first & last names in a database

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

Guest

I downloaded names and addresses for a mailing list from a property
appraisers' website, and created an Access Database using the information.
The names and addresses, as well as other pertinent information, are comma
delineated on the property appraiser's website. However, the last name is
first, and the first name is last. Is there a way to reverse the names
either in Access or in Notepad (which is where the downloaded information is
saved until it is imported into Access), so when I print the envelope, the
name appears as it should, i.e. John L. Doe, instead of Doe John L? Thank
you for any help you can give me.
 
Busy in Paradise,

Do you mean that the first name and last name are in separate fields, or
both in the same field (i.e. both enclosed within the one comma in the
comma delimited data)? If they are separate, you actually don't have a
problem, but just thought I would check your meaning. If they are in
the same field, you can run an Update Query to update YourAddressField to...
Mid([YourAddressField],InStr([YourAddressField]," ")+1) & " " &
Left([YourAddressField],InStr([YourAddressField]," ")-1)
This will work for most names, but not in the case of Lastnames with 2
words such as De Vinci and Von Sturmer.
 
Back
Top