IIF function

AndyBell

Hi

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?

Thanks

Andy

AndyBell

Fixed by changing to:

[IIF(<frxDBDataset2."Sold"> = 'Yes','Sale Date:','' )]

What I'm puzzled by is I used the Report editor to build my expression and it inserted [frxDBDataset2."Sold"] into the IIF statement when <frxDBDataset2."Sold"> was needed.

Surely the editor should insert the right syntax?

Andy