Hide and Display field in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help!

I have two date fields. Target Date and Revised Target Date. I want to
show the Revised Target Date in the report if there is one, but hide the
Target Date Field. If there is no Revised Target Date, then I want to show
the Target Date field but hide the Revised Target Date. Can anyone tell me
how to do this?
 
How about a text box with Control Source of:
=Nz([Revised Target Date], [Target Date])

If you want them in different places on the report, you could use this kind
of thing:
=IIf([Revised Target Date] Is Null, [Target Date], [Revised Target
Date])
 
Hello Myra, Try the following:
In the design of your report
1) Set visible = no for both fields (target and revised dates)
2) Add an unbound object on your report
3) Type in the unbound object the following
=iif([RevisedDate] is not null, [RevisedDate],[TargetDate])
Hope this will work

George


Ο χÏήστης "Myra" έγγÏαψε:
 
Back
Top