Help with syntax

[accesskid]

I need to work out a new field, called status and what needs to be behind it as in the layout is shown below



Target Date = Today then = "New", If Target Date < Today then "OverDue" Else "Outstanding".

If anyone knows what syntax code i need, help would be much appreciated

[Bob Fitz]

Hi

Is this a new field in a table or a new textbox on a form?

[accesskid]

Hi,

It isnt actually within access, but i assume the syntax will be the same within report builder ?

I am making a report, this will be a calcultated field.

[Bob Fitz]

Hi

I'm still not sure about what you are doing but I think you need a nested IIF expression .

You may like to try this:
IIF([Target Date] = Date(), "New", IIF([Target Date] < Date(),"OverDue", "Outstanding". ))

If this is the Control Source of a control it will need to start with an = sign
=IIF([Target Date] = Date(), "New", IIF([Target Date] < Date(),"OverDue", "Outstanding". ))