DSM Labs data.accdb: Difference between revisions

Line 8:

== Log ==

Nov 18, 2020 - in the DSM_Labs_data.accdb, Julie rename the current L_Labs_DSM with L_Labs_DSM_old and also relabel the new_Labs_DSM with L_Labs_DSM. in this way, all the queries set up by Tina will still work.

Nov 18, 2020 - in the [[DSM_Labs_data.accdb]], Julie rename the current [[L_Labs_DSM table]] with L_Labs_DSM_old and also relabel the new_Labs_DSM with L_Labs_DSM. in this way, all the queries set up by Tina will still work.

Nov 18, 2020 - Julie saved a copy of the pre Oct 1, 2020 of access ~~contining~~ the old DSM data and the Oct 29,2020 copy of new dsm lab data in the subfolder versions

Nov 18, 2020 - Julie saved a copy of the pre Oct 1, 2020 of access containing the old DSM data and the Oct 29,2020 copy of new dsm lab data in the subfolder versions

Oct 29,2020 - Julie went back to the batch files from 2019 to Oct2020 dumped data from Alun, replaced updated the D_IDs which had changes, compiled and imported the new DSM Data into the DSM_Labs_data.accdb

Oct 29,2020 - Julie went back to the batch files from 2019 to Oct2020 dumped data from Alun, replaced updated the D_IDs which had changes, compiled and imported the new DSM Data into the [[DSM_Labs_data.accdb]]

and relabel it 2020-10-29_DSM_Labs_data.accdb

Oct 2020 - Julie found some duplicates and/or missing lab tests in the L_Labs_DSM due to changes in D_ID when sent to Alun and when ~~impoeted~~ to ACCESS.

Oct 2020 - Julie found some duplicates and/or missing lab tests in the [[L_Labs_DSM table]] due to changes in D_ID when sent to Alun and when imported to ACCESS.

=== version 2020-09-30 ===

@@ Line 8: / Line 8: @@
 == Log ==
-Nov 18, 2020 - in the DSM_Labs_data.accdb, Julie rename the current L_Labs_DSM with L_Labs_DSM_old and also relabel the new_Labs_DSM with L_Labs_DSM. in this way, all the queries set up by Tina  will still work.
+Nov 18, 2020 - in the [[DSM_Labs_data.accdb]], Julie rename the current [[L_Labs_DSM table]] with L_Labs_DSM_old and also relabel the new_Labs_DSM with L_Labs_DSM. in this way, all the queries set up by Tina  will still work.
-Nov 18, 2020 - Julie saved a copy of the pre Oct 1, 2020 of access contining the old DSM data and the Oct 29,2020 copy of new dsm lab data in the subfolder versions
+Nov 18, 2020 - Julie saved a copy of the pre Oct 1, 2020 of access containing the old DSM data and the Oct 29,2020 copy of new dsm lab data in the subfolder versions
-Oct 29,2020 - Julie went back to the batch files from 2019 to Oct2020  dumped data from Alun, replaced updated the D_IDs which had changes, compiled and imported the new DSM Data into the DSM_Labs_data.accdb
+Oct 29,2020 - Julie went back to the batch files from 2019 to Oct2020  dumped data from Alun, replaced updated the D_IDs which had changes, compiled and imported the new DSM Data into the [[DSM_Labs_data.accdb]]
 and relabel it 2020-10-29_DSM_Labs_data.accdb
-Oct 2020 - Julie found some duplicates and/or missing lab tests in the L_Labs_DSM due to changes in D_ID when sent to Alun and when impoeted to ACCESS.
+Oct 2020 - Julie found some duplicates and/or missing lab tests in the [[L_Labs_DSM table]] due to changes in D_ID when sent to Alun and when imported to ACCESS.
 === version 2020-09-30 ===