Help with two criteria in an IIF statement.

[Orozvik]

Hi, i have probably a simple query rule to write but not so for me. I would be greatful in anyone on this forum can provide me with the help i need to get it right. Thanks ahead of time.

Here is the quiery rule im trying to write supported by the excel attachment.

Invoice Date Drop Date Obsolete
20120113 20130501 No
20130113 20120501 Yes
20130113 0 No



The Obsolete Field will hold this code in teh Query field box.

Obsolete: IIf([tbl0100Data]![DROP_DATE]<>0,IIf([tbl0100Data]![INVOICEDT]>=[tbl0100Data]![DROP_DATE],"Y","N")) So what im asking for is if the drop date is not equal to "0" and the Invoice Date is Greater than the Drop Date to enter a "Y" for yes, otherwise a "N" for no. This

I don't know if i should use a nested IIF which apparently i don't know how to set up correctly, or if i shoud use a "And" with one If?



Any help would be greatly appreciated....thank.s

[June7]

Your expression does not include value if DROP_DATE = 0

Obsolete: IIf([tbl0100Data]![DROP_DATE]<>0,IIf([tbl0100Data]![INVOICEDT]>=[tbl0100Data]![DROP_DATE],"Y","N"), something here)


But maybe just:

Obsolete: IIf([tbl0100Data]![DROP_DATE]<>0 AND [tbl0100Data]![INVOICEDT]>=[tbl0100Data]![DROP_DATE],"Y","N")