selecting row among duplicated ones in VBA
- by Elaine Kuo
ArcGIS 9.3 Arcobject
I wanna select one row of each duplicated SIDs in a field below.
(an attribute table of a shape file)
The priority is R S = I 0
Therefore, among SID 87, FID1 will be selected.
(SID 88, STATUS will be S+I)
(SID 89, FID 6 will be chosen)
Please kindly advise VBA cord to run the selection and thanks.
FID SID STATUS
1 87 R
2 87 O
3 88 I
4 88 S
5 89 I
6 89 R
7 89 I
8 89 S