access table transpose two fields

Andreas Sperling 40 Reputation points
2023-11-30T13:13:03.53+00:00

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 abc@domain.de;def@dom@domain.de;ghi@domain.de;jkl@domain.de;nop@domain.de;.....
group2 aaa@domain.de;bbb@domain.de;ccc@domain.de;ddd@domain.de;...
group3 ...

What I need:

group1 abc@domain.de
group1 def@domain.de
group1 ghi@domain.de
group1 jkl@domain.de
.
.
.
group2 aaa@domain.de
group2 bbb@domain.de

How can I do this best and easily?

Best regards Andreas

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
337 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
853 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Andreas Sperling 40 Reputation points
    2023-11-30T16:03:41.4066667+00:00

    Hello,

    I had an inspiration!

    I did it with split function and two recordsets!

    Thanks in advance

    best regards Andreas

    0 comments No comments