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 (1) |
Tidak ada komentar:
Posting Komentar