BIG BIG Problem with a query

  • Thread starter Thread starter MarkusGriesb
  • Start date Start date
M

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.
 
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
 
Back
Top