Iff null?

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

I have a report that has System Description....if a user is assigned to the
system then the FullName should show up however if the FullName is blank then
I want the LocationDescription to show up...can this be done if so how?
Thanks
Michelle
 
Michelle said:
I have a report that has System Description....if a user is assigned to the
system then the FullName should show up however if the FullName is blank
then
I want the LocationDescription to show up...can this be done if so how?
Thanks
Michelle
Click to expand...

Calculate a field in the report's query:

System Description: Iif(IsNull([FullName]),[LocationDescription],[FullName])

HTH - Keith.
www.keithwilby.com
 
I tried both ways and they both give me the same result....if the FullName is
blank then it give me a blank filed and does not give me the
LocationDescription, however if the FullName is not null then it gives me the
FullName.
What I want is....
System Description Full Name LocationDescription
Ann Smith Ann Smith UP-LUB
CON-LAB CON-LAB
Dave Smith Dave Smith CON

(the FullName and LocationDescription will not be on the report just the
System Description)

Thanks
Michelle
 
Back
Top