i have one table including four columns. ( Job#, Operation_code, Item, Qty). one job may have different operations. for exp, job 1 have 5 operations, job 2 have 7 operations, job 3 have 3 operations,and Qty is moving from one operation to other untill it reach to the last operation. in my out put i want to show if the qty reach to the last operation, it shows last operation in extra column. can u please help.