Conditional Calculated Value

[raweber]

Conditional Calculated Value - Resolved

I have an unbound Text Box in a form that is for showing active days in a project. If the [CompletionDate] txt box is empty, I want it to show Date()-[DateRecieved] but if [CompletionDate] is occupied, I want it to show [CompletionDate]-[DateRecieved].

I've attacked this a few different ways but I'm too new to Access to make it work.

Access 2003, but upgrading to Access 2007 sometime relatively soon (i.e. Access 2007 shouldn't break the process).

Thanks, Rob

 

[plog]

You need to use the IIf function (http://www.techonthenet.com/access/functions/advanced/iif.php) in conjunction with the IsNull function (http://www.techonthenet.com/access/functions/advanced/isnull.php) and the DateDiff function (http://www.techonthenet.com/access/functions/date/datediff.php)


=Iif(IsNull([CompletionDate]), DateDiff("d", [DateReceived], Date()), DateDiff("d", Date(), [CompletionDate]))

 

[raweber]

Very elegant, and thanks for the quick reply!

I was trying to do somthing in VBA, but this works much better for my purposes.