IsNull question

[Simon Sweet]

I have a report that has text fields displaying data linked to a query field. I need to add an IsNull expression into the report text field that will display the message "no record" if the field turns up blank. Currently, the text field contains the following query name/field reference:


ODADAS (Recent)_MaxOfValidThru

This turns out the data I need, but when no data is found I want it say "no record". Thanks in advance.

[jya]

In your query, one of your columns could be an expression that uses an IIF statement

Expr: IIF(IsNull([fieldname],"no record",[fieldname])

Of course, you need to make sure that the report text field references the column name.

[Simon Sweet]

How do I do this? Right now my field reference is: ODADAS (Recent)_MaxOfValidThru. How do I place the if statement using the field reference? Thank you for your help.

[jya]

I am assuming that you have a fieldname called 'ODADAS (Recent)_MaxOfValidThru'. If so, replace it with this expression

IIF(IsNull([ODADAS (Recent)_MaxOfValidThru]),"no record",[ODADAS (Recent)_MaxOfValidThru])

[Simon Sweet]

Thank you so much.