Seperating Email Addresses using a Query

[Guest]

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?

 

[Guest]

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.