Query where values are compares

[marcvanderpeet12]

Dear all,



Ik have the following query (see attachment). I want to include in this query something through which I can compare the values of the first "type EPE" and the values after it ("EPE gemiddeld" and "EPE_laag").

So certain values from different categories have to be compared against a norm. If the item is from category x and values are above the norm of category x (these values are outlined in the table) value 1 has to be showed if below it has to show value 2. I want to do this for 4 different categories with norm values.

Anybody help on how i can i accomplish this?

Dear regards, Marc

[rpeare]

so you want a formula to compare fields

usually that's done with an IIF statement (immediate if) or formula in a quey. For instance if you wanted to see if EPE_LAAG was greater than EPE_LAAG_NORM you'd have something like:

LAAGCheck: iif(EPE_LAAG > EPE_LAAG_NORM, "LAAG > NORM", "LAAG <= NORM")