null values

[ssiroky]

I'm running a report where one field has null values. If the value is null for this particular field, the record is thrown out. I need to be able to show all records whether they are null or not. I tried to make a formula to show null values as well as not null values: if isnull (field name) then "no data". This didn't work as it put no data for the null fields, but left the rest blank. Is there a formula I can't create that will show all values?

Thanks in advance for any help.

 

[Madawc]

You're almost there. try if isnull ({field name}) then "no data" else {field name}.

Madawc Williams
East Anglia, Great Britain

 

[pgtek]

hi
is your field numeric or string?

pgtek

 

[ssiroky]

I have two. One is a date field, the other is a string. If one is null, the other is null as well.

 

[pgtek]

hi
can you specified with one is the sring and the other date

list your field name and the name of the null field your using to select from if isnull

thanks

pgtek

 

[pgtek]

hi
try this
if
(isnull ({field name})or
{field name} = " &quot
then "no data"
else
{field name}

cheers

pgtek

 

[ssiroky]

thanks everyone for the help.....I got it to work