Access 2007 syntax error in query

[ivanver]

The following sql code in query:

SELECT
1 AS RedObr,
1 AS Nom,
1 AS Maks,
1 AS ISv33,
1 AS Izr,
1 AS Nor,
IIf( RedObr >= Nom AND RedObr <= Maks, Maks - RedObr,
IIf(Izr - ISv33 > Maks – Nom,
IIf(Izr <= Nor – Maks, Izr, Maks-Nom),
IIf(Izr <= Nor – Maks, 0, Izr - ISv33))) AS ISv43
FROM Dummy
WHERE 1 =1;



At saving answers: Syntax error (missing operator...
What's wrong?
Problem is isolated down.

Best regards, Ivan

[ivanver]

Mistake is in using hyphen instead of minus sign

[RuralGuy]

So is this thread resolved? Are you ready to use the Thread Tools and markn this thread as Solved?

[ajetrumpet]

So is this thread resolved? Are you ready to use the Thread Tools and markn this thread as Solved?

I love it! I can set my watch by these posts...