access table transpose two fields

Question

Hello,
It's not easy for me to describe what I want. :-)

I have a database table with two fields. In one field is an Active Directory Group, in the other field are the member of the group. In some groups there are 300 to 700 users separated by a semicolon. But now I want to split the users into a column representation.

What I have:

group member
group1 @domain.de;def@@domain.de;@domain.de;@domain.de;@domain.de;.....
group2 @domain.de;@domain.de;@domain.de;******@domain.de;...
group3 ...

What I need:

group1 ******@domain.de
group1 ******@domain.de
group1 ******@domain.de
group1 ******@domain.de
.
.
.
group2 ******@domain.de
group2 ******@domain.de

How can I do this best and easily?

Best regards Andreas

Answer 1

Hello,

I had an inspiration!

I did it with split function and two recordsets!

Thanks in advance

best regards Andreas