Null values in reports

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

Guest

I have several reports that list instructor names. I want the report to
display "None Listed" if the value for the instructor is null. I have
entered =Nz([Instructor], "None Listed") in the text box control source but
I keep getting "#Error" in all my reports. What am I doing wrong?
 
Could the fact that the query underlying the report is a union query be the
problem? I created a new query using the "union query" as the table in the
new query & pulled down all of its fields, but I still get the same error
message when using the new query in the report.
 
Make sure the name of the text box is not "Instructor".

--
Duane Hookom
MS Access MVP
--

Donna said:
Could the fact that the query underlying the report is a union query be the
problem? I created a new query using the "union query" as the table in the
new query & pulled down all of its fields, but I still get the same error
message when using the new query in the report.

Donna said:
I have several reports that list instructor names. I want the report to
display "None Listed" if the value for the instructor is null. I have
entered =Nz([Instructor], "None Listed") in the text box control source but
I keep getting "#Error" in all my reports. What am I doing wrong?
Click to expand...
Click to expand...
 
Donna said:
I have several reports that list instructor names. I want the report to
display "None Listed" if the value for the instructor is null. I have
entered =Nz([Instructor], "None Listed") in the text box control source but
I keep getting "#Error" in all my reports. What am I doing wrong?
Click to expand...

Most likely, the problem is that the text box is named
Instructor. If it is, change it to something else such as
txtInstructor.
 
Yep, that's exactly what I did wrong. Thanks

Marshall Barton said:
Donna said:
I have several reports that list instructor names. I want the report to
display "None Listed" if the value for the instructor is null. I have
entered =Nz([Instructor], "None Listed") in the text box control source but
I keep getting "#Error" in all my reports. What am I doing wrong?
Click to expand...

Most likely, the problem is that the text box is named
Instructor. If it is, change it to something else such as
txtInstructor.
Click to expand...
 
Back
Top