Code VBA tim row cua table
mainguyenthinh79 > 29-04-13, 11:57 PM
Chao cac chien huu.
Minh dang gap kho khan nhu sau:
Minh co 01 bang , bay gio minh muon viet code de tim cung partyId neu co MovmentType la Term ( Max Term) thi se lay cac Movement tren dong Term nay, neu partyID nao khong co Movementtype la Term thi lay toan bo cac row .
Cac ban giup minh voi.
id PartyId MovementType EffectiveDate NewAgentType NewRecruitedBy NewReportsTo
78920 128157 App 10/14/2004 FC 117442 121596
186025 128157 Tran 2/1/2009 FC 117442 152314
197718 128157 Tran 7/1/2009 FC 117442 166626
197761 128157 Prom 7/1/2009 UM 117442 166626
222047 128157 Dem 4/1/2010 FM 117442 166626
222726 128157 Tran 4/1/2010 FM 117442 152314
223164 128157 Tran 4/1/2010 FM 117442 152314
254504 128157 Dem 1/1/2011 FC 117442 152314
280319 128157 Tran 8/1/2011 FC 117442 121595
282054 128157 Tran 8/1/2011 FC 117442 166626
282149 128157 Prom 8/1/2011 PUM 117442 166626
302570 128157 Prom 1/1/2012 UM 117442 166626
330160 128157 Prom 7/1/2012 SUM 117442 166626
353909 128157 Dem 1/1/2013 UM 117442 166626
362977 128157 Term 4/1/2013 UM 117442 166626