Dear all,
Trying to use a DLookUp formula in an update query to clean up a code
There are 2 tables with the following:
Update Query to modify MainCleanedCode:
DLookUp("CleanedCode","CodeCleanUp","DirtyCode"="MainDirtyCode")
The query runs but I am not getting anything updated.
Your help is greatly appreciated.
Trying to use a DLookUp formula in an update query to clean up a code
There are 2 tables with the following:
- MainTable which Contains the fields: MainDirtyCode and MainCleanedCode
- CodeCleanUp which Contains the fields: DirtyCode and CleanedCode
Update Query to modify MainCleanedCode:
DLookUp("CleanedCode","CodeCleanUp","DirtyCode"="MainDirtyCode")
The query runs but I am not getting anything updated.
Your help is greatly appreciated.