Replacing Null Values with Values from Another Table

[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

 

[John W. Vinson]

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.

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

John W. Vinson [MVP]