Re: [MS_AccessPros] Replacing e-mail addresses with names

 

Dan-

It would help to see the SQL of your UPDATE query and perhaps some example contents of the fields you're trying to change and what you expect as a result.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Dec 30, 2013, at 7:40 PM, dancg86@yahoo.com wrote:

I have a field in a table that contains e-mail addresses.  Sometimes there is one e-mail address sometimes multiple.  I created SQL to change the e-mail to the persons name.  It works great as long as there is only one e-mail address in the field.  I have searched the Microsoft websites as well as several others and they have been no help. I tried using "Application.SetOption "Default Find/Replace Behavior",1" and it does not do anything to help me.  I am currently using a update query with separate table to complete this task, but as more people join the company the table is getting very bulky. Is it possible for the REPLACE function to search "any part of field" in SQL? Also if anyone can suggest another way to accomplish this I am open to new way of accomplishing it.

 

I am  using Access 2007 with Windows 7 professional.

 

Thank you,

 

Dan

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (2)

Recent Activity:

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___