Nested IF Statement Error help in Access

[thecitylight]

Can anyone please figure out what's wrong with this query formula. I'm
getting a syntax error in Access. Thank You.

0),0),iif(NOT([NBV122008]-[current]*12<0),[NBV122008],([NBV122008]-

[current]*12))

 

[raskew via AccessMonster.com]

Hi -

Does either [Cost] or [Accum] have the potential of being less than zero, i.e.
a negative number?

Bob

Can anyone please figure out what's wrong with this query formula. I'm
getting a syntax error in Access. Thank You.

0),0),iif(NOT([NBV122008]-[current]*12<0),[NBV122008],([NBV122008]-

[current]*12))