IIf statement
Increase the horizontal width of the display box.
--
Build a little, test a little.
"jmoore" wrote:
Wish I could do a "Reply to all" for such great response and tips. I
realized after trying the suggestions that I needed to write this as equals
not null. The code below displays the correct information when the two
fields match. However, when they do not, all that displays is a series of
pound signs (########). No text displays at all.
=IIf([EndDate]=[BeginDate],"Review Completed on: " & [BeginDate],"Review
Completed From " & [BeginDate] & " to " & [EndDate])
Thanks.
"KARL DEWEY" wrote:
Try this --
=IIf([EndDate] Is Null, "Review Completed on: " & [BeginDate], "Review
Completed From " & [BeginDate] & " to " & [EndDate])
--
Build a little, test a little.
"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.
|