If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Reverse first & last names in a database
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. |
#2
|
|||
|
|||
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. -- Steve Schapel, Microsoft Access MVP Busy in Paradise wrote: 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Encrypt AccesS File? | milest | General Discussion | 2 | February 9th, 2005 07:58 PM |
Images in a database | Franz | General Discussion | 10 | October 7th, 2004 09:35 AM |
Database Window Gone | DaveB | General Discussion | 2 | July 29th, 2004 12:24 AM |