runtime error 3075 (1 Viewer)

Hansi · Jun 14, 2018

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

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

June7 · Jun 14, 2018

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 · Jun 14, 2018

Warning to other forum members: Double post.

runtime error 3075 (1 Viewer)

Hansi

New member

June7

AWF VIP

The_Doc_Man

Immoderate Moderator

Similar threads

Users who are viewing this thread