How can this excel formula be imitated in Access?

[prvnchdry]

I have the below formula in excel that needs to work in a new calculated field of Access 2010.

=IF((ISBLANK(Mydate)),IF(Deadline date>TODAY(),"Not sent (Deadline approaching)", "Not sent (Past due)"),IF(Mydate<=Deadline date,"On time","Not on time"))



Kindly help.

[June7]

If in a table Calculated field or in a textbox:
IIf(IsNull([MyDate]), IIf([Deadline date]>Date(), "Not sent (Deadline approaching)", "Not sent (Past due)"), IIf([MyDate]<=[Deadline date], "On time", "Not on time"))

If in a query:
IIf([MyDate] Is Null, IIf([Deadline date]>Date(), "Not sent (Deadline approaching)", "Not sent (Past due)"), IIf([MyDate]<=[Deadline date], "On time", "Not on time"))

[prvnchdry]

Using this I get an error as "this expression.. cannot be used in a calculated column" . Am I going wrong somewhere?

[June7]

Not all expressions can be in a Calculated field. I did verify that the IIf() and IsNull() functions are available to Calculated column. However, I forgot to verify Date(). It is not available. Cannot do this calc in table. Do in query or textbox.

[prvnchdry]

Not all expressions can be in a Calculated field. I did verify that the IIf() and IsNull() functions are available to Calculated column. However, I forgot to verify Date(). It is not available. Cannot do this calc in table. Do in query or textbox.

Hi again....Sorry but I am pretty new to MS Access and was comfortable with simple formulas in a calculated field but not sure how to proceed with query or a text box.... Any help in here would be much appreciated!

[June7]

In textbox ControlSource property but precede with = sign.

In a query, review http://www.fontstuff.com/access/acctut02.htm