IF AND IF Function Question

[backer]

I need an IF statement that I can use in a Query that will provide an "OVERDUE" if both of two conditions are met. I thought there was a way that you can combine two IF statements to do this. When I enter the below in my Query, I get an error "Undefined function 'IF' in expression". Could someone please tell me how to make this work.

S: IF([DateRecd] Is Null And IF([DaysHeld]>[MaxDays],"OVERDUE","&quot)

 

[GHolden]

Try

IIf (IsNull([DateRecd]) And ([DaysHeld]>[MaxDays]),"Overdue","&quot There are two ways to write error-free programs; only the third one works.

 

[SgtJarrow]

The line should read:

IIF(IsNull([DateRecd]) And IF([DaysHeld]>[MaxDays],"OVERDUE","&quot) If we knew what it was we were doing, it would not be called research, would it? - Albert Einstein

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer
robert.l.johnson.iii@citigroup.com

 

[r937]

IIF(IsNull([DateRecd])
,IIF([DaysHeld]>[MaxDays],"OVERDUE","&quot
,"&quot

rudy

http://rudy.ca/

 

[backer]

Thanks a lot. I tried the first solution and it worked well, so I didn't need to try the others. Thanks for your help.