Hi all
I'm try to work out the report which link up Invoice and invoice detail files. The orginal format like below :
Invoice No Name Item Code Description Qty Amount
12345 Smith A01 ABC 1 10.00
12345 Smith A02 Delivery 1 3.00
12345 Smith A03 Admin Fee 1 2.00
How can Ii list the data like this :
Invoice No Name Item code Description Amt Delivery Admin Total
12345 Smith A01 ABC 10.00 3.00 2.00 15.00
IP Logged