if statement

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

 

[Ken Snell]

Try the IIf function:

IIf(COLA Is Null, 0, COLA)

 

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

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