I need to update my table to consolodate the amtpaid for each billnbr. I have these fields billnbr,invnbr,line and amtpaid.
What I would like to do is make the amtpaid for each billnbr(group by) reflect a total for each invnbr. When I'm done the table
will look like this.
zb1234,50168,1,4234.50 ( the amtpaid for 50168 and 50169) all lines will have same values just different amt per Invnbr
View Complete Post