Replacing Null Values with Values from Another Table

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

Guest

I have a query with one field that occasionally has a null value. I would
like to replace any null values with a proxy value.

I would get that proxy from another table in the database which would like
to another field in the current table to determine which value to use as a
proxy.

Is this possible? Any suggestions would be much appreciated.

Thanks,
Carissa
 
I have a query with one field that occasionally has a null value. I would
like to replace any null values with a proxy value.

I would get that proxy from another table in the database which would like
to another field in the current table to determine which value to use as a
proxy.
Click to expand...

NZ([localfieldname], DLookUp("[remotefieldname]", "[remotetable]",
"[linkfieldname] = " & [localfieldname])

John W. Vinson [MVP]
 
Back
Top