Report will list unlisted phone number (1 Viewer)

[mrrayj60]

I run a report to produce a phone list, I can only put the name in the book if they opted in (new law). But some just want to be listed in the book but not their unlisted phone numbers. This logic lists everything as 'unlisted'
Can anyone see the problem I have?
They are checkboxes with the fields as control.

=IIf([optinphonebook]=True And [unlisted]=False,[phone],'unlisted')

Thanks, Ray

 

[gemma-the-husky]

maybe you have Nulls, not falses - that would do it, I think.

hard to see by inspection, also