runtime error 3075

[Hansi]

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

It get syntax error (comma) in SELECT statement. Anyone know how to fix it?

 

[June7]

You need to research how to use domain aggregate functions. What you have is totally invalid. That SQL statement is so nonsensical I can't even begin to suggest how to fix. Here is a good source to learn SQL https://www.w3schools.com/sql/sql_intro.asp

 

[The_Doc_Man]

Warning to other forum members: Double post.