If Statements

[m17347047711116]

Have a report
would like the report title to change depending on the values on the report

[Field1]
[Field2]

If [field1] is completed i would like the report title to read "JOB POSTING"

If [field1] & [field2] are entered
i would like the report title to read "JOB AWARD"

 

[Fornatian]

Add an unbound control instead of the report title caption and set the control source to:

=IIF(Not(IsNull([Field1]),"OneCaption","OtherCaption")

Ian