null record

[Tony]

if the field(text) of record is null, then the query result of the field
would be "ABC" instead of "blank".

Can i do it?

Thanks a lot.

 

[Glenn]

Try

Expr1: IIF(IsNull([FieldName]),"ABC",[FieldName])

Rgds,
Glenn

 

[Tom Ellison]

Dear Tony:

You can transform null values using the Nz() function. See online
help for details. For you case:

Nz(text, "ABC")

if the field(text) of record is null, then the query result of the field
would be "ABC" instead of "blank".

Can i do it?

Thanks a lot.

Tom Ellison
Ellison Enterprises - Your One Stop IT Experts

 

[Tony]

Glenn

Thx a lot.

Try

Expr1: IIF(IsNull([FieldName]),"ABC",[FieldName])

Rgds,
Glenn

-----Original Message-----
if the field(text) of record is null, then the query result of the field
would be "ABC" instead of "blank".

Can i do it?

Thanks a lot.


.