Try adding a control with [PO_Desired_Recv_Date] as its source. You can hide
the control.

Access has a habit of rebuilding the query when the report is run and if it
decides it does not need a field it will drop it from the select clause.
Since the field [PO_Desired_Recv_Date] is buried in the NZ function it may be
missed as being required. Putting it into a control as the control source and
hiding the control should take care of the problem. Be sure you name the
control something other than the name of the field.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

MNJoe wrote:
Just as a test I tried this. =nz([Line_Desired_Recv_Date],"99/99/99") and
this worked. For some reason I put in the PO_Desired_Recv_Date and I get
#error for output. ????? Yet when I output just the PO_Desired_Recv_Date it
outputs the po date.