I have two tables, each with COMGID as unique key.
One table is CL, the other tblRevisedetails.
They have some fields in common, I want to update the fields in
tblRevisedetails with the corresponding values in CL.
I come up with the following query using the querybuilder. It is busy
for a while (2/3 secs more or less) but nothing gets changed!!!!
Who knows where am I missing what? (besides intelligence ofcourse :p)
UPDATE CL INNER JOIN tblRevisedetails ON CL.ComGid =
tblRevisedetails.REVISIE_OKGR_ID SET
tblRevisedetails.REVISIE_Huidigerevdatum = [CL]![RevisieDatum],
tblRevisedetails.REVISIE_ENA = [CL]![ENA], tblRevisedetails.REVISIE_DZB
= [CL]![DZB], tblRevisedetails.REVISIE_CR = [CL]![CR]
WHERE (((tblRevisedetails.REVISIE_Huidigerevdatum) Is Null));
Greetings Henro