Syntax Error in Query

[dvent]

Hi All,

I cannot find the issue with this query field.

The error I receive is "Syntax error (comma) in query expression.

Expr1: IIf(IsNull([Actual_RL_3rd_Reimport]),(IIf(IsNull([Actual_RL_2nd_Reimport]),([Actual_RL_1st_Reimport])),([Actual_RL_2nd_Reimport])))

Can anyone spot my issue?

Thanks in advance
dvent

 

[MStef]

Try next:
Instead of , put ;

 

[dvent]

Try next:
Instead of , put ;

where?

 

[MStef]

In your query.

 

[dvent]

This:

Expr1: IIf(IsNull([Actual_RL_3rd_Reimport]);(IIf(IsNull([Actual_RL_2nd_Reimport]);([Actual_RL_1st_Reimport]));([Actual_RL_2nd_Reimport])))

obviously will not work!

 

[jjturner]

missing 3rd (if false) argument in your 2nd IIf statement

 

[dvent]

missing 3rd (if false) argument in your 2nd IIf statement

I have amended to say:

Expr1: IIf(IsNull([Actual_RL_3rd_Reimport]),(IIf(IsNull([Actual_RL_2nd_Reimport]),([Actual_RL_1st_Reimport])),([Actual_RL_2nd_Reimport]),[Actual_RL_3rd_Reimport]))

however I still receive the syntax error.



Dvent

 

[PeterF]

In your code there are to many unnesseary () that corrupt your expression.
The following works on my system.

Expr1: 
IIf(IsNull([Actual_RL_3rd_Reimport]),
   IIf(IsNull([Actual_RL_2nd_Reimport]),
   [Actual_RL_1st_Reimport],
   [Actual_RL_2nd_Reimport]),
[Actual_RL_3rd_Reimport])

Identing your expression may help finding the problem.

Expr1: 
IIf(IsNull([Actual_RL_3rd_Reimport]),
   (IIf(IsNull([Actual_RL_2nd_Reimport]),
   ([Actual_RL_1st_Reimport])[COLOR="Red"])[/COLOR],
   ([Actual_RL_2nd_Reimport]),
[Actual_RL_3rd_Reimport]))

 

[jjturner]

Dvent,

Your 2nd IIf is missing the False argument:
IIf(IsNull([myField3]), IIf(IsNull([myField2]),[myField1],[???]), [myField2])