>>try to qualify the expression with the table name as in IIF(TableName.qtyOrder>996,"g","le")
>
>Thanks. That's the first thing I tried, actually. No work 'em.
You must have some other problem - as this works fine here
It might be that the table you have in the iif is not the one you are reporting on (and no relation established etc.) - but you probably would have seen that from other fields

Arnon