Only one freight per invoice please

[67159]

I have a report pulling from a query that list a customer's total freight for each line item on an invoice. I want to list the customer's invoice freight only once per each invoice during the month. Then sum the freight for the month and show percentage of freight spent during the month's purchases. My problem is the report pulls the entire invoice's freight for each item. Here's an example.



Inv. Date Invoice No. Part No. Qty Unit Price Ext Price Freight
12/19/2014 23114555 30101 10 $8.82 $88.20 $17.50
12/19/2014 23114555 41154 5 $17.11 $85.55 $17.50
12/19/2014 23114555 40573 5 $11.69 $58.45 $17.50

$232.20 $52.50

The freight total needs to read only $17.50 since it is the invoice's total freight amount.

I hope I'm explaining this well enough to make sense. Any suggestions?

[orange]

Please show us your:
-tables and relationships
-query used for the report.

It could be a structure problem. An Invoice detail record should only be about that detail line.
If freight applies to the Order overall, then it doesn't belong on each detail line.