SELECT Mid([ASI_Action_Codes]![action_dt_tm],7,2) & "/" & Mid([ASI_Action_Codes]![action_dt_tm],5,2) & "/" & Left([ASI_Action_Codes]![action_dt_tm],4) AS [Date], Mid([ASI_Action_Codes]![action_dt_tm],9,2) & ":" & Mid([ASI_Action_Codes]![action_dt_tm],11,2) & ":" & Right([ASI_Action_Codes]![action_dt_tm],2) AS [Time], Priority.Display AS PRIORITY, ASI_Action_Codes.referring_org_id AS REFERRING_ORG_ID, ASI_Action_Codes.named_clinician_id AS NAMED_CLINICIAN_ID, DeferReasons.Display AS SLOT_PROBLEM_REASON, ASI_Action_Codes.service_id AS SLOT_PROBLEM_SERVICE_ID, Ebsx05.SERVICE_NAME AS SLOT_PROBLEM_SERVICE_NAME, Ebsx05.PROVIDER_ORG_ID AS SLOT_PROBLEM_SP_ORG_ID, Ebsx05.LOCATION_ORG_ID AS SLOT_PROBLEM_SP_SITE_ID, Ebsx04.ORG_NAME AS site_name, Specialties.DISPLAY AS SLOT_PROBLEM_SPECIALTY INTO ASI_DataSheet
FROM ((((ASI_Action_Codes INNER JOIN DeferReasons ON ASI_Action_Codes.action_reason_cd = DeferReasons.CODE) INNER JOIN Priority ON ASI_Action_Codes.priority_cd = Priority.CODE) INNER JOIN Ebsx05 ON ASI_Action_Codes.service_id = Ebsx05.SERVICE_ID) INNER JOIN Specialties ON Ebsx05.SPECIALTY_CD = Specialties.CODE) INNER JOIN Ebsx04 ON Ebsx05.LOCATION_ORG_ID = Ebsx04.ORG_ID
ORDER BY Mid([ASI_Action_Codes]![action_dt_tm],7,2) & "/" & Mid([ASI_Action_Codes]![action_dt_tm],5,2) & "/" & Left([ASI_Action_Codes]![action_dt_tm],4), Mid([ASI_Action_Codes]![action_dt_tm],9,2) & ":" & Mid([ASI_Action_Codes]![action_dt_tm],11,2) & ":" & Right([ASI_Action_Codes]![action_dt_tm],2);