Niranjan1979
New Member
Hello team,
Kindly help me in the data, I am having a access table that has EMP ID and Name. I want to delete duplicates, BUT not same name...ie, if the ID is assigned to more than one person then we should delete it. If it is same person, we have to retain it. u
Output should be only 1003 Vas, because, 1001 is assigned to jack, MAC and John, If 1001 assigned only to Jack, if should be retained, since it is assinged to MAC and JOHN we are deleting it.. kindly help
ie ,
EMP ID Name
1001 Jack
1001 Jack
1001 MAc
1003 Vas
1001 John
Output
EMP ID Name
1003 Vas
Kindly help me in the data, I am having a access table that has EMP ID and Name. I want to delete duplicates, BUT not same name...ie, if the ID is assigned to more than one person then we should delete it. If it is same person, we have to retain it. u
Output should be only 1003 Vas, because, 1001 is assigned to jack, MAC and John, If 1001 assigned only to Jack, if should be retained, since it is assinged to MAC and JOHN we are deleting it.. kindly help
ie ,
EMP ID Name
1001 Jack
1001 Jack
1001 MAc
1003 Vas
1001 John
Output
EMP ID Name
1003 Vas
