if statement

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.
 
J

John Vinson

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().
 
Top