Created AdmitDtTm query
The query created AdmitDtTm in CFE and DSM Labs Consistency check.accdb contains the "admit date and time" of a profile according to the different definitions used over time.
needs fixing: That is: Nz([FirstService_DtTm],Nz([Accept_dttm],[Arrive_Dttm])), where FirstService_DtTm is the earliest Service tmp entry DtTm for the profile as taken from Created_FirstService query . |
|