M
mohd21uk via AccessMonster.com
I have a table in an Access database which contains two fields WBS Code and
User Name. For each WBS code I would like the unique names. I have provided
an example below to illustrate this:
WBS Code Name
E0050.10 James
E0050.10 John
E0050.10 Mark
E0050.10 John
E0050.10 Mark
E0050.10 James
E0051.20 Steven
E0051.20 George
E0051.20 Steven
E0051.20 George
Required Output:
E0050.10 James
E0050.10 John
E0050.10 Mark
E0051.20 Steven
E0051.20 George
Many Thanks,
User Name. For each WBS code I would like the unique names. I have provided
an example below to illustrate this:
WBS Code Name
E0050.10 James
E0050.10 John
E0050.10 Mark
E0050.10 John
E0050.10 Mark
E0050.10 James
E0051.20 Steven
E0051.20 George
E0051.20 Steven
E0051.20 George
Required Output:
E0050.10 James
E0050.10 John
E0050.10 Mark
E0051.20 Steven
E0051.20 George
Many Thanks,