I have an expression in a query like:
If [PD] is Null this expression produces an error. I need it to return Null. Currently I use Nz like:
to put in a date that's valid but not in the table. But this is an ugly hack. Please tell me there's a more elegant way of doing this.
Code:
PV: DLookUp("[Position_Value]","[Table2]","[Position_Date] = #" & [PD] & "#")
If [PD] is Null this expression produces an error. I need it to return Null. Currently I use Nz like:
Code:
PV: DLookUp("[Position_Value]","[Table2]","[Position_Date] = #" & Nz([PD],"1/1/00") & "#")
to put in a date that's valid but not in the table. But this is an ugly hack. Please tell me there's a more elegant way of doing this.