combining columns

  • Thread starter Thread starter Jenner
  • Start date Start date
J

Jenner

I want to combine two to three columns using an If statement (eg. in excel it
is IF(D2>0,D2,IF(B2>0,B2,D2)) but the database is just getting too large for
excel. Any ideas as to how I'd go about this?

Thanks
 
Your IF statement does NOT combine columns but selects based on values.
Access does the same with IIF function.
IIF(Test, True results, False results)
Or nested as you did --
IIF(Test, True results, IIF(2nd test, True results, False results))
Or
IIF(Test, Field1, IIF(2nd test, Field2, Field3))
 
Back
Top