IIF doing the only if all the time

[misscrf]

I tried asking this with another similar thread, but no response, so sorry for the redundancy. I have like all my reports done, except this one. I have a report that shows an inventory for monitors. There is a field for workstation serial number in the table that feeds the report. I have the following expression to specify whether there is a workstation attatched to the monitor or not:

=IIf([WS] Is Not Null,"Yes","No")

Problem is, I only see "Yes" and I know that some should be saying no because there are records in the table/record source that have an empty field for the workstation.

What am I doing wrong please?
Thanks!

 

[jebry]

Hi!

Try this:

=IIf(Nz(Len([WS]),0)<>0,"Yes","No")

This will take care of cases where WS might be an empty string.

hth


Jeff Bridgham
bridgham@purdue.edu

 

[misscrf]

Ok all. I kept working on this, and solved the problem all on my own! I put the expression in the control source/query and it worked! Woohoo!

 

[misscrf]

Thanks for the suggestion! I will try that sometime to see the difference!