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]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WMI script to fetch DELL Servicetag 1
Seperate ID Prefix and ID Number 2
Cascading combo/query in tables 0
System.Collections.Generic.IList<MicroLite.SerialNumber>' is lessaccessible than method 1
query multiple tables with identical column names 4
VBA - retrieve data on last create named range from previous inserted named range 0
Transform Rows to Columns 1
URGENT! Macro help on incremental numbering for printing 2

Back
Top