View Full Version : If Statements


m17347047711116
03-16-2002, 10:01 AM
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
03-16-2002, 10:10 AM
Add an unbound control instead of the report title caption and set the control source to:

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

Ian