error and cannot figure out why

[king07]

hello

i have the following expressions:

Status: IIf([Next Discussion Due]<Date(),"OverDue",IIf([Next Discussion Due]>Date(),"UpComing",Iif([LastReviewDate]>=#11/1/2006# And([LastReviewDate]<=#10/31/2007#,"Complete")))

when i try to close my query and save i get the error of the expression you entered has a function containing the wrong number of arguments??

any ideas on what i am doing wrong??

 

[boblarson]

Right after this
And([LastReviewDate]<=#10/31/2007#,"Complete")))
you need an argument after "Complete"
And([LastReviewDate]<=#10/31/2007#,"Complete", "Whatever If False Here")))