Display or Display other

Q

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.
 
J

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.
Click to expand...

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]
 
Top