difficuiltly with NULL VALUES?

[abhishekpant]

i am dealing with a report which have three field
room no price comments
101 120 non smoking
102 140 <null>
103 80 repaired

i want to change the null value to "unknown" and be sorted in accending order,so the new table should look like

room no price comments
101 120 non smoking
103 80 repaired
102 140 unknown

can anyone help?///////

 

[synapsevampire]

Create a formula for display and sortation purposes containing something akin to:

if isnull({table.comments})
or
{table.comments} = "" then
"Unknown"
else
{table.comments}

Sortation is probably under the Report pulldown.

-k