n Wed, 17 Sep 2008 12:29:01 -0700, annie techwriter wrote:
Yes, it can be displayed in a reoort or query.
The problem though is with [Status].
Is it indeed a Text datatype field and the word "Closed" is stored in
the table field (that is the report's record source)?
Or is it a look up field that displays the word "Closed" but stores a
Or is it a Check Box Yes/No field?
If [Status] is a Text field.....
In an unbound text control on your report:
If the [Status] field is a Text datatype then, if the value is
"Closed" the current date will display, otherwise the control will be
If [Status] is a lookup field, then you need to know the number value
that equates to "Closed". Let's assume it's 3.
=IIf([Status] = 3, Date(),"")
If [Status] is a Yes/No check box, then
=IIf([Status] = -1,Date(),"")
The above assumes that [Status] is either -1 (for Closed) or 0 (for
Not Closed or whatever)
You would use similar expressions in a query (without the = sign)
ClosedDate:IIf([Status] = "Closed",Date(),"")
The used the [ClosedDate] field in the report.
Please respond only to this newsgroup.
I do not reply to personal e-mail