Display or Display other

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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