Display or Display other

[Quandary]

How can I make a report show information from one field, if there is data in
the column and from another field if there is no data in that column.
For example I have a table that has two columns named serialNumber and
ServiceTag. I would like the report to list the serialNumber if available and
if not list the ServiceTag.

 

[John Vinson]

How can I make a report show information from one field, if there is data in
the column and from another field if there is no data in that column.
For example I have a table that has two columns named serialNumber and
ServiceTag. I would like the report to list the serialNumber if available and
if not list the ServiceTag.

You can use the NZ() function to do this. Set the Control Source
property of a textbox to

=NZ([SerialNumber], [ServiceTag])


John W. Vinson[MVP]