Three Possible responses using Iff

[ypma]

Hello fellow users of Access, I require a little guidance .

On my form I have two fields .

Field one is a date field "DateMovedIn"
Field two is an unbound field with the control source sent to :=IIf([DateMovedin]<Now()-1095,"Longer than 3 Years","Less than 3 Years")

Works fine, but if the date field is blank the response is "Less than 3 Years".

I wish to have a third response if the date field is Blank "No Date in Date move in"

Any advise would be appreciated

Regards Ypma

For this post I am using access 2010 windows 7

 

[pbaldy]

Try

=IIf(IsDate(DateMovedin),IIf([DateMovedin]<Now()-1095,"Longer than 3 Years","Less than 3 Years"),"No Date in Date move in")

 

[ypma]

Paul, thank you very much for providing me with a solution. For some reason I thought I needed another IFF. Brain still working , but not stopping at every floor.
Thanks again

Bob.

 

[pbaldy]

LOL! I know the feeling Bob.