Centralized data.accdb Change Log: Difference between revisions
Ttenbergen (talk | contribs) m →2015-Jun-24: m |
Ttenbergen (talk | contribs) |
||
| Line 1: | Line 1: | ||
This is the change log for [[Centralized_data.mdb]]. See [[Centralized data.mdb Requested Changes]] for its requested changes. | This is the change log for [[Centralized_data.mdb]]. See [[Centralized data.mdb Requested Changes]] for its requested changes. | ||
==2015-Jul-06== | |||
ran | |||
UPDATE L_Log INNER JOIN s_HospitalCodes_updt ON L_Log.R_HospitalPrevious = s_HospitalCodes_updt.Code | |||
SET L_Log.[R_HospitalPrevious] = [CodeNr] | |||
WHERE (((s_HospitalCodes_updt.Code)<>CStr([CodeNr]))); | |||
and | |||
UPDATE L_Log SET L_Log.R_HospitalPrevious = "" WHERE (((L_Log.R_HospitalPrevious)="0")); | |||
==2015-Jun-24== | ==2015-Jun-24== | ||