Creating a New Table

[JJPetersen1]

I can’t get my head wrapped around this. I have a table with several fields but I want to create a new table, merging the email addresses into a new field (separated with a semi-colon)



Starting Table (Fields: Unit and Email)

Unit A john.doe@gmail.com
Unit A bill.smith@gmail.com
Unit A george.jones@gmail.com
Unit B Allen.jackson@gmail.com
Unit B Richard.nixon@gmail.com
Unit C Ronald.reagan@gmail.com

New Table (Fields: Unit and Email)

Unit A john.doe@gmailcom; bill.smith@gmail.com; george.jones@gmail.com
Unit B Allen.jackson@gmail.com; Richard.nixon@gmail.com
Unit C Ronald.reagan@gmail.com

Any help would be appreciated

[Welshgasman]

I wouldn't.
If you insist, look at allen browne's concatenate.?
http://allenbrowne.com/func-concat.html

[JJPetersen1]

This is a temporary table, which I would update when needed. I can concatenate with a query about how do limit the unit list as described above

[Welshgasman]

See the link?

[Micron]

I can concatenate with a query about how do limit the unit list as described above

Say what?
If you're saying you can do the concatenation then it seems that the missing part is creating the table. Then use a make table query using the concatenation query as a table.

[CJ_London]

If what you are trying to do is have a concatenated list of hyperlinks per your example then this cannot be done. Best you can do is concatenate the address as text.

Perhaps if you explain why you want to do this, what you will do with the single field when you gave it we might be able to suggest an alternative way

[Welshgasman]

Why a table?, when a query would do just as well and hold current data???