calculation of difference using different fields depending on prod

  • Thread starter Thread starter sverre
  • Start date Start date
S

sverre

Hi

I have a problem with calculating differences in queries. I need to use
different
fields in my calculation depending on what product I do the calculation for.
One query can have several different products.

I now I can use the iif in the syntax but the syntax becomes very long and
hard to
understand.

Are there other solutions that could be better?

Sverker
 
Hi

I have a problem with calculating differences in queries. I need to use
different
fields in my calculation depending on what product I do the calculation for.
One query can have several different products.

I now I can use the iif in the syntax but the syntax becomes very long and
hard to
understand.

Are there other solutions that could be better?

Sverker
Click to expand...

sounds somewhat like improper normalization. post your table
structure(s) ... well the parts relevant to the question.
 
Back
Top