I am trying to calculate freight charges on orders. My trouble is the table I am using list the total freight charge on each line .

The data look like this

ORDER# QTY    PART#    PRICE   EXT_PRICE   FREIGHT

000001     2         5505       10.00     20.00              14.95

000001     3         5504        5.00      15.00              14.95

Total                                                    35.00               29.90   

Total freight should be 14.95 for the whole order

Now a customer may have 2 or three orders that I want to total the EXT_PRICE AND FREIGHT but each time I do I end up calculating the freight for each line when it should be calculated one time.