Validation in Form in One filed (Name - Processed / Checked Before Due Date )

[Abdul]

Hello ,



I am a new User and in Access World , I have these Formula in excel =IF(AK4="No","-",IF(AND(T4="Yes",L4>=V4),"Yes",IF(AND(T4="No",L4> =S4),"Yes","No") and I want these validation in form in text box [Processed / Checked Before Due Date ]


Coloumns
AK = ProcessorandCheckersameperson, T = CheckingRequired, L = DueDate, V = CheckingDate , S = ProcessingDate

I created these =IIf(([ProcessorandCheckersameperson]="No")And ([CheckingRequired]="Yes",[DueDate]>=[CheckingDate],"Yes")And([CheckingRequired]="No",[DueDate]>=[ProcessingDate]),"NotChecked","Checked")

But I guess I am wrong some where , my project is due tomorrow

Thank you all in advance to helping me in solving these

Awaiting for the reply

[June7]

Are these all text type fields?

This is what it looks like to me:

=IIf([ProcessorandCheckersameperson]="No", "-", IIf([CheckingRequired]="Yes" AND [DueDate] >= [CheckingDate], "Yes", IIf([CheckingRequired]="No" AND [DueDate]>=[ProcessingDate], "NotChecked", "Checked")))

[Abdul]

Are these all text type fields?

This is what it looks like to me:

=IIf([ProcessorandCheckersameperson]="No", "-", IIf([CheckingRequired]="Yes" AND [DueDate] >= [CheckingDate], "Yes", IIf([CheckingRequired]="No" AND [DueDate]>=[ProcessingDate], "NotChecked", "Checked")))

Thank you for your reply


highlighted in blue in form

attached is form screen shot

The validation is such that
ProcessorandCheckersameperson filed has a formula
CheckingRequired has Combo box Yes/NO in form

rest all are text box

If [ProcessorandCheckersameperson] is "No" "-" and IF [CheckingRequired] is yes then [DueDate]>=[CheckingDate]) "Yes" And IFCheckingRequired]="No" And[DueDate]>=[ProcessingDate]),"Yes","No")

I tried these not working
=IIf([ProcessorandCheckersameperson]="No", "-", IIf([CheckingRequired]="Yes" AND [DueDate] >= [CheckingDate], "Yes", IIf([CheckingRequired]="No" AND [DueDate]>=[ProcessingDate], "NotChecked", "Checked")))

Thanks for your time