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
column headings: School, Campus, AdminNo, ModuleCode, ModuleGrp
for the module code i wanna retrieve the distinct data. I know how to obtain distinct data using select distinct
i want to put into datagridview with 2 columns, moduleCode and AdminNo
the output should be like:
ModuleCode AdminNo
EG3901---12344Y
-----------23456H
EG3902---64738U
-----------99393J
-----------63738B
.
.
.
im aware of setting criteria like country=mexico
but right now, i cant list out all the ModuleCodes as the data varies as the file changes, and there are over 30k records.
Thanks!