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

Concatenated field dropping decimal places 1
Carriage Return Error in Concatenated Field 2
Calculated age field not populating after 1/1/09 1
Calculating age with If statement 2
concatenated field in a report is not sorted 1
Format part of a concatenated control 1
calculated field, changing value for check box in report 5
Display query results only if field is not null 3

Top