Translate an excel formula into access

[harpscardiff]

In my worksheet there are 3 columns; 1. Date Completed (J), 2. New Review Date(K) and 3. Status(L)

I'm currently migrating from excel to access, the finishing tounces are needed, like the status.

The following excel function I want to convert to access

=IF(K1="","Outstanding",IF(K1<TODAY(),"Outstanding","Complete"))

(K1= Next Review Date)

I did do a search, but I couldn't really find anything.

How do I convert this please?

 

[QTNM]

Code Conversion ...

Hope this helps .... where will you be running this from?? Query, form, report, module ???? It may make a difference to the way you reference K1 .... let me know ..... but you can start with this .... ( put extra spacing to for better readability ! )

EXCEL CODING:
=IF(K1="","Outstanding",IF(K1<TODAY(),"Outstanding","Complete"))

ACCESS CODING:
=iif ( isnull ([K1]) or [K1] = " " , "Outstanding",iif ( [K1] < now(),"Outstanding","Complete"))


Let me know how that works out for you ....

QT