Search results

  1. T

    Stupid simple syntax problem: Iff (IsNull...)

    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 ...
  2. T

    Create relationship as each excel table is imported into db

    Hello, I’m trying to combine a couple of Subs that I’ve found online. The first one imports every excel file within a specified folder (in the example below, this is ‘strPath’) into Access (but doesn’t set any primary key). The second Sub is supposed to create a relationship between 2...
Back
Top Bottom