BIG BIG Problem with a query

[MarkusGriesb]

I have a complex problem and I do not know how to solve it.

I have a query with several fields
1. Against Payment
2. Free of Charge
3. Value of part
4. handling costs
5. customs duty
6. freight costs
7. Total(=expression which calculates the sum of 3-6)

The problem I have is, that when it is free of charge, then the
total(7.) is only allowed to sum handling costs and customs duty --

How can I do that ?

Thanks a lot for your help.

 

[Glenn]

In field 7 assuming free of charge is True or False........

Total: iif([Free of Charge]=true,[handling costs]+[Freight
Costs],[Value of part]+[handling costs]+[customs duty]+
[Freight costs])

Rgds,
Glenn