Code:
Folks Please Help me with this

I have an Access database and have a query return data like this...

______________________________________________________________________

SID	Skill		PersonCode		PersonName
______________________________________________________________________

1	Management	412			Bill Gates
2	Programming	412			Bill Gates
3	Martial Arts	412			Bill Gates
4	Programming	413			Steve Jobs
5	Dancing		413			Steve Jobs
6	Management	414			Suzuki samako
7	MartialArts	414			Suzuki samako


What i would like to have is a query that would return this..


______________________________________________________________________

SID	Skill		PersonCode		PersonName
______________________________________________________________________

1	Management	412			Bill Gates
4	Programming	413			Steve Jobs
6	Management	414			Suzuki samako


That is.. only their Primary skills alone, HOw do i do it ?