I have a field in my report where I want to display text if the value of a database field is "Yes" and display nothing if it is not "Yes"
I've entered this:
[IIF([frxDBDataset2."Sold"] = "Yes","Sale Date:"," " )]
I've tried double equals, changing double quotes to single, and so on but I always get this error message "Identifier expected".
Can anyone tell me what I'm doing wrong?