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
|
|||
|
|||
Seperating Email Addresses using a Query
I have 1 table called Customers which has many fields, inlcuding an
EmailAddress field. I query the table so that it returns all the email addresses and creates a New Table (I have already done this, no prob). Lets say that when the query is executed, it returns 500 email addresses and creates a table with 500 records. But now, I have noticed that some of the entries in the EmailAddress field in the original Customer table have multiple email address seperated with a semi-colon, SO, in actual fact, there are more than 500 email address (somewhere around 650). When I do the query, how would I be able to extract all the email addresses (650) individually and then make the new table with 650 records instead of 500? |
#2
|
|||
|
|||
Seperating Email Addresses using a Query
In this I used a field named E-mail.
Use criteria Like "*;*" Alternately append to the same table and update the table using the below -- - append Expr1: Left([E-mail],InStr([E-mail],";")-1) - update Expr2: Trim(Right([E-mail],Len([E-mail])-InStr([E-mail],";"))) Do this until there are not more records with semicolon. "dwalsh77" wrote: I have 1 table called Customers which has many fields, inlcuding an EmailAddress field. I query the table so that it returns all the email addresses and creates a New Table (I have already done this, no prob). Lets say that when the query is executed, it returns 500 email addresses and creates a table with 500 records. But now, I have noticed that some of the entries in the EmailAddress field in the original Customer table have multiple email address seperated with a semi-colon, SO, in actual fact, there are more than 500 email address (somewhere around 650). When I do the query, how would I be able to extract all the email addresses (650) individually and then make the new table with 650 records instead of 500? |
Thread Tools | |
Display Modes | |
|
|