Hi,
I have a report which is based on a query that includes the following expression named "PreInstallationInspectionDate" (I know it's a long name)
In the report, I would like the PreInstallationInspectionDate field highlighted if the field is blank. I've tried using IsNull([PreInstallationInspectionDate]), Nz([PreInstallationInspectionDate]) and both IsNull and Nz with the Dlookup formula used in the query but nothing is working.
Any suggestions?
I have a report which is based on a query that includes the following expression named "PreInstallationInspectionDate" (I know it's a long name)
Code:
DLookUp("[PreInspectionDate]","tblWorkOrder","CandidateID=" & [CandidateID])
In the report, I would like the PreInstallationInspectionDate field highlighted if the field is blank. I've tried using IsNull([PreInstallationInspectionDate]), Nz([PreInstallationInspectionDate]) and both IsNull and Nz with the Dlookup formula used in the query but nothing is working.
Any suggestions?