Loop access database

[12345_abcde]

hi, i have a access database containing the following:

SEG,AMK,101427Y,EG3902,EG3902-G1
SEG,AMK,101427Y,EGS650,EGS650-G1
SEG,AMK,103852S,EG3901,EG3901-G1
SEG,AMK,103852S,EG3904,EG3904-G1
SEG,AMK,103852S,EGS104,EGS104-G1
SEG,AMK,103852S,EGS650,EGS650-G1
SEG,AMK,106581C,EG3901,EG3901-G1
SEG,AMK,106581C,EG3902,EG3902-G1
SEG,AMK,111713M,EG3901,EG3901-G1
SEG,AMK,111713M,EG3902,EG3902-G1

i wanna loop to get: example, EG3091 - 103852S
- 106581C
- 111713M

Means a list with Distinct Module codes and the students taking the module to come out like the example i listed.

i have retrieved the distinct module list from my database using SQL command already.

anyone teach me how should i go about doing it?

Can i use For loop? if yes, how can i say if the student matches the module?

Thanks in advance!