if statement

  • Thread starter Thread starter if statement
  • Start date Start date
I

if statement

does access support the following SQL?:

if(COLA is NULL, 0, COLA)

I get a syntax error when i try to run my code, i'm
wondering how i can make this work.
 
does access support the following SQL?:

if(COLA is NULL, 0, COLA)
No.

I get a syntax error when i try to run my code, i'm
wondering how i can make this work.
Click to expand...

Use the IIF() function instead of IF().
 
Back
Top