Report-not required to print if field is null-concatenated field q

A

Anni

Please tell me how to configure the field in a report not to print if the
value is null (simple concatenated field in query (ie [age 2] &" "&years
old). The age field is not always entered, so in the report it reads "years
old", which does not look good!
 
D

Dorian

In ControlSource property for field, try
=NZ(ColumnName,[Age] & ' years old','')
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
How to return Max date or Null (if there is a Null present) 4
Calculating age with If statement 2
Calculated age field not populating after 1/1/09 2
Display query results only if field is not null 3
Reading Previous record of field and inserting it into current If Is Null?? 2
concatenated field in a report is not sorted 1
Suppress comma in calculated field given Null 2

Top