Breaking apart email into Two fields

[kcaenj]

I have a field called Mail thath as the employees email address. I want to sepearate this into two different fields callled Mail1 and Mail2. The separation would occur at the "@" symbol and this would no longer be included. I would like to be able to do this without removing or altering the original Mail field. So it could create two new fields for each half of the address.

Thanks,

KC

 

[Norie]

Why not just do it in a query rather than creating new fields?

The SQL would look something like this:

SELECT [Employee Emails].Mail, Left([Mail],InStr([Mail],"@")-1) AS Mail1, Mid([Mail],InStr([Mail],"@")+1) AS Mail2
FROM [Employee Emails];