IIf statement
Probably the following should be your expression.
=IIf(IsNull([EndDate]),"Review Completed on: " & [BeginDate],
"Review Completed From " & [BeginDate] & " to " & [EndDate])
If this does not work as you expect, post back and tell us what the problem
is. "Does not work" is not a good description of the problem.
Do you get an error message, the wrong thing displayed, nothing displayed, or
does something else happen?
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
jmoore wrote:
I would like one of two different statements to display on a report based on
whether one field is null. The two fields are BeginDate and EndDate. If
EndDate is null, it should read "Review Completed on: [BeginDate]. If not
null, it should read "Review Completed From [BeginDate] to [EndDate]. I
tried the IIf statement below, but it did not work.
=IIf([EndDate] Is Null,"(“Review Completed on: “ [BeginDate])",(“Review
Completed From “ & [BeginDate] & "to " & [EndDate]))
Thanks.
|