January 13, 2010 at 5:27 pm
Sorry I know this is not the best way to put data, but couldnt find a better way.
this is the data i have and I want to find out the records which had same [Package Grp No] and [Account] and then update the column to the first of those group.
[Package Grp No][Account][Package Item No][Opportunity Name][Opportunity Stage][Course Start Date][Opportunity ID][Group: ID][PackageID]
PGN-0312638aaPIT-0068897000725GInvoiced30/9/20090062000000Af3Wxa0520000007P1fba0E200000046Xsm
PGN-0312638aaPIT-0068898001920G Offer Declined by Student20/7/20100062000000Af3ZNa0520000007P1fba0E200000046Xsn
PGN-0312639bbPIT-0068899062024AInvoiced7/3/20110062000000Af7Toa0520000007P59fa0E200000046efk
PGN-0312639bbPIT-0068900059619M Invoiced7/12/20090062000000AeX5Va0520000007P59fa0E200000046efl
PGN-0312640ccPIT-0068902063957C 9 - Conditional COE Received7/2/20110062000000Af7lxa0520000007P59pa0E200000046egy
PGN-0312640ccPIT-0068901061399M 9 - Conditional COE Received6/2/20130062000000Af7n1a0520000007P59pa0E200000046egx
PGN-0312641ddPIT-0068903003896GInvoiced1/3/20100062000000Af7naa0520000007P59za0E200000046ehC
PGN-0312641ddPIT-0068904013905G 9 - Conditional COE Received19/7/201000620000007iFxTa0520000007P59za0E200000046ehD
PGN-0312642eePIT-0068905061397B 9 - Conditional COE Received26/7/20100062000000Af842a0520000007P5Aia0E200000046el6
PGN-0312642eePIT-0068906032417K Invoiced4/1/20100062000000Af859a0520000007P5Aia0E200000046el7
PGN-0312643ffPIT-0068907053607G 11 - Finalised7/6/20100062000000Af91Ca0520000007P5Axa0E200000046emv
PGN-0312643ffPIT-0068908032410F 11 - Finalised4/1/20100062000000Af8E9a0520000007P5Axa0E200000046emw
PGN-0312643ffPIT-0068909006487A 10 - Unconditional Offer Accepted25/7/20110062000000Af9rJa0520000007P5Axa0E200000046emx
Please help.
Thanks
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply