Report Calculation question

Yahoo Archive
1
This should work:

iif(JobNum = ?, " ",JobNum)
2
How would I create a calculated field in Report Builder that identifies whether a field is not blank? I am in the PartDtl table and I want a calculated field that looks to see if the PartDtl.Jobnum field has a value in it. That field is not a number field but a character field. How would I evaluate this statement:

IIF(PartDtl.JobNum = ' ???' , "Job #" , ' ' )

What should the '???' be? If there's a value for Jobnum, I want it to print "Job #". If not, then it should be blank.

Thanks,
Jasper





[Non-text portions of this message have been removed]