I need some help with blank values....

[dandman71]

I need a expression that will pull data for employees skills. I have a database that holds the info, and i can pull it correctly. People with no skills also appear, but with no text for teh skills field. I would like it to read, 'no skills'.

How would I include that, a IIF statement? I woould think it is IIF({database_field)}={database field},{database field},"no skills&quot

It accepts the expression, but does not return the no skills the they have none/


Any suggestions?

 

[Ngolem]

try this

If not isnull({Table.skills}) or
length(trim({Table.skills})) > 0 then
{Table.skills}
else
"No Skills";

Jim Broadbent

 

[bdreed35]

You need to test the field for null. If you try use a field in a formula that contains a null, the formula will stop evaluating.

Try this: iif(not(isnull({database_field})),{database field},"no skills&quot

~Brian