>Can this be worked into the report expression where one already exists?
>
>Wait a minute! I seem to have found a situation where a dual IIF already exists! Seems all I was forgetting to do was add a comma. Looks like you have to be very careful though with parenthesis, field name locations, etc.
>
>I will use your last suggestion Elmer and tack it into the report expression to see what happens.
You can put nvl() around a complicated expression.
To print question marks for missing values (nulls), use the report expression:
nvl((((Some complicated expression))), "???")
See also SET NULLDISPLAY.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
