Display a customized Text based on the Value of a Field

[JithuAccess]

Hello Guys,

The Record Source of my Report is a query. There is a field "Reviewed By" in this query. I want to display the Text "No" if the Reviewed By field is Null and "Yes" if the Reviewed By Field is Not Null in my Report.

Can we do this in a Report?

Thanks

 

[pbaldy]

Try

=IIf(IsNull([Reviewed By]), "No", "Yes")

 

[JithuAccess]

Try

=IIf(IsNull([Reviewed By]), "No", "Yes")

Thanks a lot. It worked Perfect.

 

[pbaldy]

Happy to help!

In the long run, spaces and symbols in object names aren't worth the bother. In this case, the space required me to add brackets. I'd simple use ReviewedBy, some would use Reviewed_By (the underscore is the only symbol that won't cause issues).