Hi every body,
I am new in this discussion form.
In fact, I have the following problem:
I have a selection query of three tables, in which I select the data with certain conditions. It is imperatif that a filed of one of the tables be equal to another one (under certain conditions!).
At the criteria line of this field I have generated the tha following condition:
Iif(RSKS97!NPO3>0 , RSKS97!NPO3,
Iif(RSKS97!NPO2>0 , RSKS97!NPO2,
Iif(RSKS97!NPO1>0 , RSKS97!NPO1,
Iif(RSKS02!NPOR>0 ,[RSKS02!NPOR,))))
That means, it checks three fields in the second table. If they are zeros, then it will be equal to a field in the third table.
But unfortuntly, it doesn't work. An error message indicates that the syntax of the expression is not correct.
Have you any suggestion. It would be really appreicitated.
I am new in this discussion form.
In fact, I have the following problem:
I have a selection query of three tables, in which I select the data with certain conditions. It is imperatif that a filed of one of the tables be equal to another one (under certain conditions!).
At the criteria line of this field I have generated the tha following condition:
Iif(RSKS97!NPO3>0 , RSKS97!NPO3,
Iif(RSKS97!NPO2>0 , RSKS97!NPO2,
Iif(RSKS97!NPO1>0 , RSKS97!NPO1,
Iif(RSKS02!NPOR>0 ,[RSKS02!NPOR,))))
That means, it checks three fields in the second table. If they are zeros, then it will be equal to a field in the third table.
But unfortuntly, it doesn't work. An error message indicates that the syntax of the expression is not correct.
Have you any suggestion. It would be really appreicitated.