Hello world,
I'm trying to replace all the blank values within a table (the table is named "Methane_all2") for a field called "Var01". I'm using expression builder within a simple Select Query. The expression I have in there is:
=IIf ( IsNull ( [Methane_all2]!["Var01"] ) , -9999 , [Methane_all2]!["Var01"] )
But this keeps giving me the following message:
"The Visual Basic Module contains a syntax error." "Check the code, and then recompile it." I'm using Access 2003, and the above syntax is what was recommended to use for this situation. I've also tried using the Nz function, with the same result.
Help!!!!!!
I'm trying to replace all the blank values within a table (the table is named "Methane_all2") for a field called "Var01". I'm using expression builder within a simple Select Query. The expression I have in there is:
=IIf ( IsNull ( [Methane_all2]!["Var01"] ) , -9999 , [Methane_all2]!["Var01"] )
But this keeps giving me the following message:
"The Visual Basic Module contains a syntax error." "Check the code, and then recompile it." I'm using Access 2003, and the above syntax is what was recommended to use for this situation. I've also tried using the Nz function, with the same result.
Help!!!!!!
