I have payment records that are in my table and need to update that table with the lastest pay date(non zero wgt) for all billnbrs that match.
I have billnbr,invnbr,line,payment,wgt,paydate fields defined in table. The payments with zero wgt are the ones needing updated they are like a surcharge but need to show the actual paydate for the entire billnbr.
data:
zb1234,50168,1,34.50,0,4-29-2010
zb1234,50168,2,34.50,0,4-29-2010
zb1234,50169,1,4200.00,0,4-29-2010
zb1234,50169,2,4200.00,400,5-27-2010
What I would like to do is make the paydate for each billnbr(group by) reflect the true final payment which is the non zero wgt record. The table would look like this after update step.
zb1234,50168,1,34.50,0,5-27-2010
zb1234,50168,2,34.50,0,5-27-2010
zb1234,50169,1,4200.00,0,5-27-2010
zb1234,50169,2,4200.00,400,5-27-2010
Thanks.
Thanks.
View Complete Post