combining columns

[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

 

[KARL DEWEY]

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))