Code:
DoCmd.RunSQL (" SELECT (LEA , SO_ID , CRM_ORDER , SO_STATUS , TASK_NAME , TASK_STATUS , TASK_WG , ASSIGNED_DATE , CLOSED_DATE , ACCOUNT_NO , SERVICE_TYPE , ORDER_TYPE) FROM All_Detail" & _
" DLookup('lea','so_id','crm_order','so_status','task_name','task_status','task_wg','assigned_date','closed_date','account_no','service_type','order_type')" & _
" INSERT INTO Main( Report_Date, [LEA , SO_ID , CRM_ORDER , SO_STATUS , TASK_NAME , TASK_STATUS , TASK_WG , ASSIGNED_DATE , CLOSED_DATE , ACCOUNT_NO , SERVICE_TYPE , ORDER_TYPE] )" & _
" VALUES( rep_date, DLookup('lea','so_id','crm_order','so_status','task_name','task_status','task_wg','assigned_date','closed_date','account_no','service_type','order_type') );"), True
Last edited: